| |
 |
|
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
Q3_1997_S2 DATA_TBS2
YES
40 40 0
Q4_1997 SYS_SUBP9 Q4_TBS1 YES 40 40 0
SYS_SUBP10 Q4_TBS2 YES 40 40 0
SYS_SUBP11 Q4_TBS3 YES 40 40 0
SYS_SUBP12 Q4_TBS4 YES 40 40 0
SYS_SUBP13 Q4_TBS5 YES 40 40 0
SYS_SUBP14 Q4_TBS6 YES 40 40 0
SYS_SUBP15 Q4_TBS7 YES 40 40 0
SYS_SUBP16 Q4_TBS8 YES 40 40 0
Monitoring
Sub-partition Statistics
Statistics are gathered at the sub-partition
level, just as for tables and partitions. The dba_tab_sub-partitions
view contains the statistics for all analyzed sub-partitions. A
sample report on sub-partition statistics in Oracle8i and Oracle
is shown below.
tab_subpart_stat.sql
--**********************************************
--
--
Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for
non-commercial use.
-- For
commercial licensing, e-mail info@rampant.cc
--
--
*********************************************
The above text is
an excerpt from:
Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts
Written by the world's top DBA and author
of over 20 Oracle books, Mike Ault shares his secrets for Oracle
DBA management scripts. This handy reference is indispensable
for all Oracle professionals who must quickly automate and
manage their Oracle databases with scripts.
This stellar book comes complete with an
online code depot full of over 200 pre-tested Oracle DBA
scripts, and covers all areas of Oracle database administration
including data files, tablespace, table and index management
scripts. Based on more than 20 years full-time experience, Mike
Ault brings his expertise to the public with this fantastic
book. Your time savings from a single script is worth the price
of this great book.
http://www.rampant-books.com/download_adv_mon_tuning.htm
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
