Oracle Reference

Oracle Reference

Create/Build/Rebuild/Drop Scripts
Constraints Scripts
General Information Scripts
Locking Scripts
MTS Scripts
Parallel Server Scripts
Performance Scripts
Administring PL/SQL & Sql Scripts
Privilege, Profiles, Sessions & User Scripts
Rollback Segment Scripts
Space Management & Reliability
Backup/Recovery
Jobs
Indexes

Create/Build/Rebuild/Drop Scripts
Database creation script 9i
Script to create a build script for a database
Script to build all tablespaces
Script to create all roles
Script to create all users
Script to grant system privileges
Script to grant object privileges
Script to build database links
Script to build synonyms
Script to build views
Script to build views
Script to grant object privileges
Script to build non partitioned tables
Script to build partitioned tables
Script to build non partitioned indexes
Script to build partitioned indexes
Script to build triggers
Script to build redo logs

Script to count all rows in all tables
Script to describe all tables
Script to drop all objects for a user
Script to drop all public synonyms for a user
Script to list all objects for a user

Constraint Scripts
Lists table dependencies
Lists foreign keys without indexes

General Scripts
List time database has been up
List number of tables analyzed or not for a user

Locking Scripts
List users blocking via locks
Lists locks fully decoded
List sql text from locks
List locks & their sid and serial # to kill
List locks held by a specific user

Multi Threaded Server Scripts
List MTS information
Help sizing the shared pool for MTS

Parallel Server Scripts
List Parallel Server Information
List Pinging

Performance Scripts
Snapshot tuning report
Reactive tuning script (if its slow)
Redolog tuning report - with notes
Lists all objects that waits are currently occuring on
List redo log buffer contention
List file I/O
List buffer contention
List latch statistics
List cursor usage

Fix Chained rows in a table

PL/Sql & SQL Scripts
Lists all users and sql for active sessions, easy to alter to show sql for all users
Script to create source code of pl/sql objects (not triggers)
Script to recompile all INVALID objects in a schema
List all invalid packages and those without bodies

Privileges, Profiles, Sessions & user Scripts
Lists sessions and UNIX process id
Save a users password to a file for later user
Lists all grants to a user
List users idle time

Rollback Segment Scripts
Lists rollback segment statistics
Lists users sql that is accessing rollbacks now
Lists all active users and their rollback segment

Space Management & Reliability Scripts
Unix script to create a logfile of all Oracle errors in the alertlog
Freespace in a tablespace
Tables with more that 10 extents
Extent report (pl/sql)
Extent report for 9i (local tablespaces) (pl/sql)

Backup & Recovery
Unix script to export all databases
Script to create a script for a cold backup on NT

Jobs
List all jobs
Break all jobs - stops them from running
List a job, parameter of job no.

Indexes
List all indexes that need rebuilding