The Oracle wait event model was originally introduced in Oracle7. Wait event information is gathered by the Oracle MMON background process, stored in intermediate x$ structures in a circular SGA buffer, and later transferred to Oracle10g dba_hist tables. Oracle 10g introduced the Active Session History (ASH) as part of the Diagnostics and Tuning Read more…
The Query Optimizer(the optimizer) The query optimizer is built-in database software. The query optimizer attempts to generate the most efficient execution plan for a SQL statement. The query optimizer considers many factors related to the objects referenced and the conditions specified in the query. This determination is an Read more…
Tuning of the database is very challenging work for the DBA. For this DBA should use Proactive strategy for the database. In Proactive strategy dba should work on few things when they are creating database. We know that for database creation parameter file is required which contains parameters & its Read more…
Tuning of the database is very challenging work for the DBA. These days client wants everything should be fast on the database. It is possible if DBA will use Proactive strategy for the database. For Proactive strategy, DBA should work on a few things when they are creating a database. Read more…