#748. You work as a programmer at Braindumps Inc. During the application development phase, you receive complaints from the Braindumps application developers that the database is slow while queuing certain tables. The application is a DSS application that has been in development for the past 6 months, but the database slowdown has been experienced only recently. The server is dedicated to one Oracle database instance that hosts the application, and has 1 gigabyte of physical memory. You followed memory-tuning guidelines and allocated approximately 164 megabytes for the total SGA. Using one of the database performance diagnostic tools, you confirmed the following: 1. The statistics are captured for the duration of 1 hour. 2. Buffer cache hit ratio is average of 73%. 3. Library cache hit ratio is average of 98%. 4. Disk sort ratio is average of 0.2% per transaction. 5. Sum of the long table scans is average of 13.5 per transaction. 6. Sum of the physical block reads of each tablespace is average of 0 with the exception of one tablespace that has the value of 2306797. What is the first action you should consider?
gen. 0.047
Forum
Master braindump