| |
 |
|
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
rem
rem Name: tab_subpart_stat.sql
rem Function : Report on partitioned table structure
rem History: MRA 6/13/97 Created
rem
COLUMN table_name FORMAT a15 HEADING 'Table'
COLUMN partition_name FORMAT a15 HEADING 'Partition'
COLUMN sub-partition_name FORMAT a15 HEADING 'Sub|Partition'
COLUMN num_rows HEADING 'Num|Rows'
COLUMN blocks HEADING 'Blocks'
COLUMN avg_space HEADING 'Avg|Space'
COLUMN chain_cnt HEADING 'Chain|Count'
COLUMN avg_row_len HEADING 'Avg|Row|Length'
COLUMN last_analyzed HEADING 'Analyzed'
ACCEPT owner1 PROMPT 'Owner to Report On?: '
SET LINES 130
START ttitle 'Table Sub-Partition Statistics For &owner1'
BREAK ON table_owner ON table_name ON partition_name
SPOOL tab_subpart_stat.lis
SELECT
table_owner,
table_name,
partition_name,
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
|
|
