#682. Several users have called to state that their normal sub-second response time for OLTP applications is now averaging three to four seconds. You find the following: • The SGA is currently at its maximum size defined by SGA_MAX_SIZE. • The GETHITRATIO for the library cache is 98%. • The reloads-to-pins is less than .25 percent when you query the V$LIBRARYCACHE view. • The hit ratio in the buffer cache has fallen from its normal level of 88 to 90 percent and is only averaging 65 percent when you look at several different the reports from STATSPACK. You have used the SHOW command to verify the current settings for the SHARED_POOL_SIZE and the DB_CACHE_SIZE parameters. Which three steps should you take to improve response time for the OLTP application users? (Choose three. First choose 1 from A and B; then choose 1 from C and D; then choose one from E and F)
gen. 0.04
Forum
Master braindump