Oracle DBA Scripts and Tips

It has come to our attention that an Oracle Development company have copied our scripts without our permission and are using them as part of their own products for which they are charging users a license fee.

As a result of this, we have decided to suspend access to our DBA scripts until further notice and we regret the impact that this decision will inevitably have upon genuine users of the scripts repository.

We are continuing to monitor the situation and would encourage you to check back in the future for developments.

Script Home

Analyze

Scripts sorted by Title

Export Table, Index & Partition Statistics ( Oracle : 8i 9i 10g )
SQL Script : This script copies all the statistics captured using the DBMS_STATS package into
Updated: 31-DEC-02
Gather Table Statistics ( Oracle : 8i )
SQL Script : Dynamically analyzes all tables for an owner
Updated: 26-SEP-02
Gather Table Statistics ( Oracle : 9i 10g )
SQL Script : Dynamically analyzes all tables for an owner using the gather_schema_stats proce
Updated: 24-NOV-04
Get System Stats ( Oracle : 9i 10g )
SQL Script : Displays the values of any System Statistics in place or in a stats table
Updated: 02-JUN-05
Import Table/Index and Partiton Statistics ( Oracle : 8i 9i 10g )
SQL Script : Uses the DBMS_STATS package to import all statistics from a table to the data di
Updated: 31-DEC-02
Index Statistics ( Oracle : 7 8 8i 9i )
SQL Script : This script validates an index and reports upon the index stats table. This scri
Updated: 28-FEB-02
List Table Statistics ( Oracle : 8i 9i 10g )
SQL Script : Uses the DBMS_STATS package to list the table, index and column statsistics
Updated: 26-SEP-05
List the Last Analyzed Date ( Oracle : 8 8i 9i 10g )
SQL Script : Lists the last analyze date for tables, indexes and partitions. This script shou
Updated: 28-NOV-02

Site Map