Welcome to KRISHNA GOPALANS DBA Scripts Pages. You will find a list of very useful Oracle Scripts for DBA's

Krishna Gopalans Oracle Page

|Home | e-mail

Database Status Monitor (Very Useful)
Lists the Tablespaces Used / Free Space
Generate a Report of the Database Status
Generate a Report of the Database Information
List all the Chained Rows in a Schema
List the datafiles,controlfiles & redologfiles
List out the extents for a specific table
List all the physical Database files groupwise
Computes the Amout of Free SGA currently
Users Connected to the Database
Library Hit Cache Ratio
Database I/0 (Read/Write) Statistics
Redo Log Monitoring
Redo Log Statistics
Rollback Segment Monitoring
Rollback Segment Statistics
TableSpaces and their Associated Datafiles
List Extents Associated with a Table Space
Validate Structures / Indexes of Tables
Get the Primay Keys of Specified Table
Get the Tables which Refer to the Specified Table
Get the Parent Tables of the Given Child Table
Generate a Script to Recreate all Tables in a Schema
Generate a Script to Recreate all Indexes in a Schema
Display a Table showing History of Log Switches
Oracle Database Creation Procedure & Scripts for UNIX

|Home |e-mail

Brought to you by:

Krishna Gopalan BE, MCA, DBA
e-mail : [email protected]
url : www.krishna-gopalan.com
Telephone : +978-453-3177
Address : 1986 Middlesex St., Apt.#35, Lowell MA 01851(USA)