Database Tuning Improvements.docVIP

Database Tuning Improvements In this section we will outline the new and improved features regarding database and instance tuning. Oracle has introduced some good features that enhance self-tuning and automated tuning. They are summarized as follows: User initiated Buffer Cache Flushing Automated Checkpoint Tuning CPU Costing Dynamic Sampling Tuning Transaction Recovery and Easy Monitoring User initiated Buffer Cache Flushing In the past, we had a facility to flush the shared pool. The FLUSH SHAREDPOOL clause of ALTER SYSTEM lets you clear all data from the shared pool in the SGA (system glob