1Z0-062 · Question #253
Which two categories of segments are analyzed by the Automatic Segment Advisor?
The correct answer is A. segments in tablespaces that have exceeded a critical or warning space threshold B. segments that have the highest growth rate in a database. The Automatic Segment Advisor primarily analyzes segments located in tablespaces that are approaching their space limits and segments that demonstrate the highest growth rates within the database.
Question
Which two categories of segments are analyzed by the Automatic Segment Advisor?
Options
- Asegments in tablespaces that have exceeded a critical or warning space threshold
- Bsegments that have the highest growth rate in a database
- Csegments that are sparsely populated and have more than 10% of free space below the high
- Dsegments that have unusable indexes
- Esegmentsfor tables created using ADVANCED ROW COMPRESSION
How the community answered
(53 responses)- A94% (50)
- D4% (2)
- E2% (1)
Why each option
The Automatic Segment Advisor primarily analyzes segments located in tablespaces that are approaching their space limits and segments that demonstrate the highest growth rates within the database.
The Automatic Segment Advisor identifies segments within tablespaces that are running low on free space, specifically those exceeding critical or warning space thresholds, to suggest actions for space reclamation.
The Automatic Segment Advisor targets segments that show the highest growth rate, indicating they are actively expanding and might benefit from space optimization or re-organization to manage storage efficiently.
While the Segment Advisor does look for sparsely populated segments, the specific condition of 'more than 10% of free space below the high' is not a standard, primary category used by the advisor in its analysis scope.
The Automatic Segment Advisor primarily focuses on segment space utilization and growth, not the usability or status of associated indexes, which falls under separate index management functions.
Segments for tables created with ADVANCED ROW COMPRESSION are already using a form of compression; the advisor's primary categories focus on identifying segments for *potential* space savings, not those already compressed.
Concept tested: Oracle Automatic Segment Advisor analysis criteria
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-space-for-database-objects.html#GUID-E5B7C214-E48F-44F4-BB94-688B575EC65C
Topics
Community Discussion
No community discussion yet for this question.