| |
 |
|
Oracle Tips by Burleson |
OCP Instructors Guide for
Oracle DBA Certification
Chapter 8 -
Miscellaneous Oracle Information
Monitoring Space
Utilization and Performance Statistics Historically
SEE
CODE DEPOT FOR FULL SCRIPT
Run these statements to produce the historical
tracking reports:
ttitle
"Extents Tracker Reports"
set linesize 180
break on segtype skip 2
break on segname skip 2
column segname format a25
column tspace format a8
column segtype format a8
column segowner format a8
column segowner heading OWNER
column segext format 999
column segext heading EXT
column segbytes format 999,999,999
column seginit format 999,999,999
column segnext format 999,999,999
column segpctinc format 99
column segpctinc heading INC
select segname, run_date, segowner, segtype, tspace, segext,
segbytes, seginit, segnext, segpctinc
from extents_tracker
order by segname, segtype, run_date;
ttitle "Space
Tracker Reports"
break on fileid on tspace skip 2
column tspace format a8
column fileid format 99
column maxspace format 9,999,999,999
column minspace format 9,999,999,999
column avgspace format 9,999,999,999
column totspace format 9,999,999,999
The above text is
an excerpt from:
OCP Instructors Guide for Oracle DBA Certification
A Study Guide to Advanced Oracle Certified Professional Database
Administration Techniques
ISBN 0-9744355-3-8
by Christopher T. Foot
http://www.rampant-books.com/book_2003_2_OCP_print.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
