[bbk5162] 第108集 -第13章 - 表空间管理 06

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

posted @ 2013-06-08 23:24  ArcerZhang  阅读(138)  评论(0)  编辑  收藏  举报