Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Author: Fernando

Posted on March 1, 2025March 1, 2025

Exadata Storage Index

mountains with white snow

Storage indexes are an Exadata feature designed to enhance performance by reducing disk I/O.

Unlike traditional B-tree or bitmap indexes, storage indexes do not store specific values to help find records; instead, they track the minimum, maximum, and null values of data in 1MB chunks of storage.

Here’s how they work:

Continue reading “Exadata Storage Index”
Posted on February 22, 2025July 11, 2025

Top 7 Oracle Wait Events Explained

body of water between green leaf trees

Oracle wait events are statistics that a server process or thread increments when it waits for an operation to complete in order to continue its processing.

Here are some of the most common Oracle wait events explained.

Continue reading “Top 7 Oracle Wait Events Explained”

Posts pagination

Previous page Page 1 … Page 5 Page 6 Page 7 … Page 33 Next page

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Step by Step Data Guard Broker Configuration in Oracle 19c
  • Oracle 19c Data Guard Configuration Step by Step
  • How to Change AWR Retention Period in Oracle Database
  • RMAN Level 0 and Level 1 Backup Script

Recent Posts

  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status
  • PostgreSQL Monitoring: How to Keep Your Database Healthy

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

Unmissable posts

  • How to Change AWR Retention Period in Oracle Database
  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • How to Find Primary Database From Standby in Oracle
  • Step by Step Data Guard Broker Configuration in Oracle 19c
  • Exadata Smart Flash Cache
  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status
  • PostgreSQL Monitoring: How to Keep Your Database Healthy

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

English EN
English EN
Spanish ES French FR

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress