 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 5 -
Automatic Storage Management
Oracle Segment Advisor
Space usage recording and reporting data is provided to the AWR
when snapshots are created and alerts are triggered. The
snapshot based statistics are created every 30 minutes. The
current space usage details of the tablespace are registered in
the AWR. MMON checks the tablespace thresholds every ten minutes
and passes the data to AWR on detecting any violations. The new segment resource estimation feature available through
OEM, estimates the amount of resources required for creating a
new segment. Oracle Database 10g estimates the amount of disk
space likely to be consumed by the object based on the structure
of a table or index and the estimated rows per table. This
feature also predicts the amount of CPU and I/O resources for
the creation process.
Automatic Undo Management
The automatic undo management feature
introduced in Oracle 9i has been improved with the following
capabilities.
Some of the undo management related
initialization parameters are eliminated in Oracle Database 10g
as they are automatically calculated.
They include max_rollback_segment,
row_locking, undo_suppress_errors, serializable,
and transaction_auditing.
Undo Tablespace Sizing Advisor helps to
size the undo tablespace based on the workload history.
Automatic undo retention tuning is enabled by default and
determines the optimal undo retention time depending on the undo
tablespace size. There is no need to manually set the undo
retention period. Proactive monitoring and notification warns of
any current or impending problems such as snapshot too old.
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
