Oracle
1Z0-054 · Question #79
You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS and note the top…
The correct answer is D. Keep the short tables in the keep buffer pool. See the full explanation below for the reasoning.
Question
You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS and note the top five events. View the Exhibit named TOPSQL and note the problems related to these statements. View the Exhibit named INSTACT and note the table scans. Which is the most appropriate solution?
Exhibits
Options
- ACreate indexes on short tables.
- BUse the CACHE hint to access long tables.
- CKeep the long tables in the keep buffer pool.
- DKeep the short tables in the keep buffer pool.
- EKeep the short tables in the recycle buffer pool.
How the community answered
(37 responses)- B5% (2)
- C8% (3)
- D84% (31)
- E3% (1)
Community Discussion
No community discussion yet for this question.