Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Easy Oracle Automation
Chapter 5 - Automatic Storage Management

Oracle Segment Advisor

The segment advisor determines whether an object is a good candidate for a shrink operation. It makes recommendations based on the amount of space that can be released and future space requirements from growth-trend information. The DBA can choose whether to implement these recommendations. The shrinks can be invoked at the segment or tablespace level.

OEM is the interface to invoke online segment shrinking. OEM offers the option of selecting various inputs and scheduling a job to call the Segment Advisor to get shrink advice. The OEM wizard can be invoked with no context, in the context of a tablespace, in the context of a schema object, or in the context of a database user.

Without context involves areas like alert table and tablespace alerts recommendations page, detected storage problems page, ADDM results page involving Segment Advisor recommendations, and maintenance page of database home page. In the context of tablespace and object involves selecting the appropriate entity and selecting a Segment Advisor menu item in OEM.

Segment Advisor collects growth trend data from segments and makes it available to advisories and reporting tools such as AWR or OEM. The AWR collects the persistent space usage statistics and stores it in the WR schema. 

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA