 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
Table ownership, creation information, and
whether they are clustered can be shown in a single report. This
report is shown in tab_rep.sql. It is important to monitor tables
soon after creation to make sure they are properly sized and their
storage parameters are appropriate. This can be accomplished through
the use of the script in tab_rep.sql , which documents how a table
was created. The Enterprise Manager application provides this data
in a very user-friendly format.
tab_rep.sql
REM
REM NAME : TABLE.SQL
REM FUNCTION : GENERATE TABLE REPORT
REM Limitations : None
clear COLUMNs
COLUMN owner FORMAT a15 HEADING 'Table | Owner'
COLUMN table_name FORMAT a18 HEADING Table
COLUMN tablespace_name FORMAT A13 HEADING Tablespace
COLUMN pct_increase HEADING 'Pct|Increase'
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|
