What solution would you recommend?
A. 1) The Exhibit DBTIME shows that the DB CPU event consumed very high % DB Time. 2) The CPU is very slow. 3) Increase the number of processors.
B. 1) hard parse elapsed time has the majority time in parse time elapsed, which is shown in the TIMEMODEL Exhibit. 2) This is due to inadequate Database Buffer Cache. 3) Increase the size of database buffer cache.
C. 1) sql execute elapsed time and parse time elapsed are consuming very high % DB Time in the TIMEMODEL Exhibit. 2) There are too many soft parses. 3) Investigate the HOLD_CURSOR parameter setting in the application and set it appropriately.
D. 1) % Non-Parse CPU is low and Soft Parse % is also low in the EFFICIENCY Exhibit. This shows that very few statements are found in the cache. 2) There are too many hard parses. 3) Investigate the CURSOR_SHARING parameter setting and set it appropriately.
Answer:D
What solution would you recommend?
A. 1) The Exhibit DBTIME shows that the DB CPU event consumed very high % DB Time. 2) The CPU is very slow. 3) Increase the number of processors. B. 1) hard parse elapsed time has the majority time in parse time elapsed, which is shown in the TIMEMODEL Exhibit. 2) This is due to inadequate Database Buffer Cache. 3) Increase the size of database buffer cache. C. 1) sql execute elapsed time and parse time elapsed are consuming very high % DB Time in the TIMEMODEL Exhibit. 2) There are too many soft parses. 3) Investigate the HOLD_CURSOR parameter setting in the application and set it appropriately. D. 1) % Non-Parse CPU is low and Soft Parse % is also low in the EFFICIENCY Exhibit. This shows that very few statements are found in the cache. 2) There are too many hard parses. 3) Investigate the CURSOR_SHARING parameter setting and set it appropriately.