This note is supplied describing the Oracle Index, its number of rows, leaf blocks and status if it is invalid or valid. For the past couple of days I was thinking how will I know if the query is optimized or not until today I had time to experiment and used SQL Hint on my [...]

This article provides guidelines for tuning an Oracle database when the main source of contention is I/O-related. Scope and Application ————————— The techniques described here can be followed when: Statspack or AWR reports show I/O wait events in the “Top 5 Wait/Timed Events” section. SQL Tracing with wait events of a database session shows it [...]

What is Explain Plan? It is an execution plan that shows the detailed steps necessary to execute SQL statements. Execution Plan steps are expressed as a set of database operators that consumes and produces rows. And the order of the operators and their implementation is decided by the Optimizer using a combination of query transformations [...]

Rebuilding database index have a role in database performance. Rebuilding the database index depends on the business rule stated by the organization.  One common reason of rebuilding the database index is after the large delete, update or insert in the database. Rebuilding the index helps re-organizing the index. Database Syntax of rebuilding the index: ALTER [...]