Oracle Database Manageability


Proactive Space Management

Database 10g introduces a non-intrusive, efficient and timely monitoring of database space, built right into the database server. Proactive tablespace management is available by default with no measurable performance impact, and it is uniformly available across all tablespace types.
The Oracle Database 10g also introduces the ability to reclaim space from a segment by shrinking it online and in-place. Shrinking of a segment makes unused space available to other segments in the tablespace and can improve the performance of queries and DML operations. The Segment Advisor analyzes a specified tablespace or a schema for objects that may be candidates for shrinking. It also performs growth trend analysis on individual objects to determine if there will be any additional space left in the object and uses this information to select candidate objects to shrink.


Technical Information
 The Self-Managing Database: Proactive Space & Schema Object Management PDF
 
Demos
 Oracle Database 10 g: Oracle Database 10 g: Proactive Space Management and Segment Advisor
     
Other Relevant Articles
 Improved Tablespace Management
   
Oracle World 2003 Presentations
 The Self-Managing Database: Proactive Space & Schema Object Management PDF
 
 

In-Memory Replay Banner