Oracle
1Z0-054 · Question #93
View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE indicate that a large amount of space is allocated to the temporary tablespace that is being used.Which action would reclaim…
The correct answer is A. shrinking the tablespace. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE indicate that a large amount of space is allocated to the temporary tablespace that is being used.Which action would reclaim the space and refresh these values?
Exhibit
Options
- Ashrinking the tablespace
- Bclosing all the current sessions
- Crestarting the database instance
- Dforcing a checkpoint or waiting for a checkpoint to occur
How the community answered
(35 responses)- A71% (25)
- B6% (2)
- C9% (3)
- D14% (5)
Community Discussion
No community discussion yet for this question.