Oracle
1Z0-054 · Question #181
View Exhibit1 and examine a portion of Active Session History(ASH) report. View Exhibit2 to examine the tablespaces. Which action would you suggest after analyzing the output?
The correct answer is D. Move SPCT table to a different tablespace that is locally managed with automatic segment space. See the full explanation below for the reasoning.
Question
View Exhibit1 and examine a portion of Active Session History(ASH) report. View Exhibit2 to examine the tablespaces. Which action would you suggest after analyzing the output?
Exhibits
Options
- AIncrease the log buffer size.
- BRebuild indexes on SPCT table.
- CDecreasing the number of free lists in segment SPCT.
- DMove SPCT table to a different tablespace that is locally managed with automatic segment space
How the community answered
(27 responses)- A7% (2)
- B4% (1)
- C4% (1)
- D85% (23)
Community Discussion
No community discussion yet for this question.