 |
|
ss
Oracle Tips by Burleson |
Chapter 8 Oracle Index
Internal Scripting
Figure 8.1 dba_view cluster for monitoring indexes
The report below provides a convenient format
for the DBA to review indexed tables and columns; it is selective
down to the single-table, single-owner level. The report should be
run after database maintenance involving table rebuilds, exports and
imports, or database rebuilds. An example of the output from the
script follows.
ind_rep.sql
rem
rem NAME: ind_rep.sql
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|
