Statspack tool

This query from the Oracle Sponge shows a query that computes wait times for sequential and scattered reads:. The script shown below to aggregate the average daily data buffer hit ratio. If you want to delve a little deeper, I go into a great deal of detail in my latest book, " Oracle Tuning: The Definitive Reference ", One of the most tedious and time-consuming jobs for Oracle DBAs is monitoring the performance of their Oracle databases.

Oracle Training from Don Burleson The best on site " Oracle training classes " are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!

Feel free to ask questions on our Oracle forum. Verify experience! Oracle8i 8. Introduction and Terminology 1. Statspack Configuration 2. Database Space Requirements 2. Installing the Tool 2. Errors during Installation 3. Gathering data — taking a snapshot 3. Automating Statspack Statistics Gathering 3. Running the Performance reports 4. Running the instance report 4. Running the instance report when there are multiple instances 4.

Configuring the Instance Report 4. Running the SQL report 4. Running the SQL report when there are multiple instances 4. Installing required packages Creating views Please check spcusr. Please check spcpkg. There are five snap shot levels 0, 5, 6, 7, 10 with 5 being the default.

Pressing without specifying a number lists all completed snapshots. To use this name, press to continue, otherwise enter an alternative. The spauto. Level Host Comment 1 27 Oct 7 rac1. Table A-1 Levels of Statistics Level. Enter a beginning snapshot ID. Enter an ending snapshot ID. Enter a name for the report or accept the default. It is used mainly as a queuing mechanism so that other resources can wait for a transaction to complete. ST Space management Enqueue : These enqueues are caused if a lot of space management activity is occurring on the database such as small extent size, several sortings occurring on the disk.

Another session is reading the block into the buffer. Another session holds the buffer in an incompatible mode to this request. Information Collected. General Performance Statistics. Addition Data: Segment Level Statistics.