Proactive Tablespace Monitoring
Threshold and Resolving Space Problems
Locally managed tablespace Resolve space problem by:
- Adding or resizing data file
- Setting AUTOEXTEND ON
- Shrinking objects
- Reducing UNDO_RETENTION
- Checking for long-running queried in temporary tablespaces
Monitoring Tablespace Space Usage
- Read-only and offline tablespaces:Do not set up alerts.
- Temporary tablespace:Threshold corresponds to space currently used by sessions.
- Undo tablespace:Threshold corresponds to space used by active and unexpired extents.
- Autoextensible files:Threshold is based on the maximum file size.
Shrinking Segments
Results of Shrink Operation
- Improved performance and space utilization
- Indexes maintained
- Triggers not executed
- Number of migrated rows may be reduced.
- Rebuilding secondary indexes on IOTs recommended
