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

Space Management

Scripts sorted by Title

10g Segment Advisor ( Oracle : 10g )
SQL Script : Sample Script in order to run the Segment Advisor from PLSQL
Updated: 02-JUN-05
Coalesce Tablespaces ( Oracle : 8i 9i 10g )
SQL Script : Coalesces All tablespaces within a database.
Updated: 26-SEP-02
Coalesce Tablespaces ( Oracle : 7 )
SQL Script : In Oracle version 7.3 and above coalescing a tablespace is very easy - there is
Updated: 18-FEB-99
Coalesce Tablespaces ( Oracle : 8 )
SQL Script : Coalesces All tablespaces within a database.
Updated: 26-SEP-02
Count Table Space Used ( Oracle : 7 8 )
SQL Script : This script calculates the actual space used by a table (and not just the space
Updated: 28-FEB-01
Count Table Space Used ( Oracle : 9i 10g )
SQL Script : This script calculates the actual space used by a table (and not just the space
Updated: 28-FEB-02
Count Table space used ( Oracle : 8i )
SQL Script : Calculates the actual space used.
Updated: 19-JUL-04
Database Datafile Listing ( Oracle : 8i 9i 10g )
SQL Script : This script lists all the database datafiles, control files and redo log files w
Updated: 18-MAR-02
Database Datafile Listing ( Oracle : 7 8 )
SQL Script : This script lists all the database datafiles, control files and redo log files w
Updated: 01-JUN-98
Database Space Info ( Oracle : 7 8 8i 9i 10g )
SQL Script : Script reports most a number of space related information
Updated: 08-JAN-02
Database Tablespace Usage ( Oracle : 7 8 )
SQL Script : This script lists gives a breakdown of who is using the space in each tablespace
Updated: 28-FEB-01
Database Tablespace Usage ( Oracle : 8i 9i 10g )
SQL Script : This script lists gives a breakdown of who is using the space in each tablespace
Updated: 28-SEP-02
Datafile Free Space ( Oracle : 8i 9i 10g )
SQL Script : This script lists the free space in each datafile. It is useful is you have ove
Updated: 03-APR-02
Does Next Extent Fit ? ( Oracle : 7 8 8i 9i 10g )
SQL Script : This scripts reports any tables,indexes,clusters (and table/index partitions) wh
Updated: 30-JUN-02
List all Tablespace FreeSpace ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script tablespace free space in bytes and percentage. Totals at foot of rep
Updated: 30-MAR-02
Move Tables to New Tablespace ( Oracle : 8i 9i 10g )
SQL Script : Dynamic script to move tables to a new tablespace
Updated: 02-JUN-05
Rebuild Indexes ( Oracle : 10g )
SQL Script : Dynamically rebuild all indexes for an owner into a given tablespace. Updated fo
Updated: 26-SEP-02
Rebuild Indexes ( Oracle : 7 8 )
SQL Script : Dynamically rebuild all indexes for an owner into a given tablespace
Updated: 11-OCT-02
Rebuild Indexes ( Oracle : 8i 9i )
SQL Script : Dynamically rebuilds indexes for an owner into a given tablespace
Updated: 19-JUL-04
SYSAUX Occupants ( Oracle : 10g )
SQL Script : Displays the contents of the SYSAUX tablespace
Updated: 28-DEC-05
Size Flash Recovery Area ( Oracle : 10g )
SQL Script : A script to estimate the size of the flash_recovery_area in 10G
Updated: 02-JUN-05
Space Usage ( Oracle : 9i 10g )
SQL Script : This procedure used a new procedure in Oracle 9i which displays a breakdown of t
Updated: 14-MAR-02
Table Extents for Given Owner ( Oracle : 8i 9i 10g )
SQL Script : This script is very similar to the List all tables/indexes extents in a given ta
Updated: 13-SEP-02
Table Extents for Given Owner ( Oracle : 7 8 )
SQL Script : This script is very similar to the List all tables/indexes extents in a given ta
Updated: 01-JUN-98
Table Extents for Given Owner ( Oracle : 8i 9i 10g )
SQL Script : This script is very similar to the List all tables/indexes extents in a given ta
Updated: 13-SEP-02
Table Extents for Given Owner ( Oracle : 7 8 )
SQL Script : This script first gives a list of tablespaces. It then prompts to enter a tables
Updated: 01-JUN-98
Table Fragmentation ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script lists details how chained or migrated rows there are within a table.
Updated: 13-SEP-02
Tablespace Fragmentation Script ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script lists details of the extents within a tablespace. This will help you
Updated: 13-SEP-02
Tablespace Mapper ( Oracle : 7 8 8i 9i 10g )
SQL Script : This script lists all used and free extents of a given tablespace. This is an ea
Updated: 04-AUG-02
Undo Statistics ( Oracle : 9i 10g )
SQL Script : This script provides a summary of the values in the v$undostat table. This table
Updated: 08-APR-03
Unused Space in extents ( Oracle : 8i 9i 10g )
SQL Script : This scripts displays details about how must unused space there is in segments i
Updated: 14-MAR-02
Unused Space in extents ( Oracle : 7 8 )
SQL Script : This scripts displays details about how must unused space there is in segments i
Updated: 01-OCT-00

Site Map