Disclaimer: =========== These scripts are provided for educational purposes only. They are NOT supported by Oracle World Wide Technical Support. The scripts have been tested and appear to work as intended. However, you should always test any script before relying on it. PROOFREAD THIS SCRIPT PRIOR TO USING IT! Due to differences in the way text editors, email packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected. Thank you.

  SCRIPT AREAS

Constraints	Object_Creation	DBA_Information	Performance	Export/Import	Privileges/Profiles
Index	Rollback_Segments	Job_Queue	Space_Management	Locking	Utilities

 

Constraints Scripts

Script For Capturing Table Constraints CR 95170 Script To Generate A Delete Cascade Report CR 95171 Check For Foreign Key Locking Issues CR 120470 Script To Report Constraints For A User CR 100840 Script To Eliminate Non-Unique Rows CR 103420 Script to Create SQL to Enable/Disable Table Constraints CR 104476 Script To Locate Tables W/O Primary Keys CR 106838 Report Table Constraints CR 125124 Generate List Of Table Dependencies CR 116486 Determine An Object's Dependencies CR 120474

DBA Information Scripts

Script For Creating A Data Base Schema Summary CR 95165 Script To Drop Some Or All Objects From Schema CR 95169 Script To Obtain Session Information CR 125122 Script To Produce A Database Summary Report CR 95175 Script To Provide Databaseperformance Overview CR 95176 Script To Show Audit Options/Audit Trail CR 95178 Report Dispatcher & Process Mapping Using Mts CR 109908 Script To Report Instance Parameters CR 135839 Script To List Programs For A User CR 104890 Verify Stored Procedures CR 135840 Report Sequence Values CR 125125 Report Redo Log Information CR 125126 List Inactive Users CR 121100 Script To Fully Describe A Table CR 135845 Script To Provide Listing Of All Database Files CR 10837 Script to Report Large Segments CR 103425 Create View To Display All Open Pipes CR 116590 Script To Monitor Session Idle Times CR 135860 Delete Commit Procedure CR 125129 Determining Connect Time Properly CR 111790 Report All Events Set In Session CR 135863

Export/Import Scripts

Script To Export Data To Fixed-Width Text CR 101494 Script To Generate Sql*Loader Control File CR 101495 Script To Export User Definitions CR 95180 Script To Report Object Owners In Database CR 103419

Index Scripts

Script To Show Data Selectivity For A Column CR 97899 Script To Report Information On Indexes CR 97904 Script To Describe All Indexes In A Schema CR 95167

Job Queue Scripts

Script To List Running Jobs CR 108528 Script To List Submitted Jobs CR 135859

Locking Scripts

Fully Decoded Locking Script CR 121094 Display Locks And Give Sid And Serial # To Kill CR 116589 Script To Return Medium Detail Locking Info CR 100949 Low Complexity Locking Info CR 121095 Display Sql Text From Locks CR 120473 Script To Display User Lock Information CR 135843 Report Sessions Waiting For Locks CR 116591

Object Creation Scripts

Script To Generate Db Link Script CR 103426 Generate Object Priv Grant Script CR 135848 Generate System Priv Grant Script CR 106840 Generate Role Creation Script CR 135849 Generate Synonym Creation Script CR 111786 Generate Create Tablespace Script CR 135850 Generate Index Creation Script CR 135851 Script To Create A Basic Replicated Environment CR 104484 View To Show Parallel Instance Number CR 108532

Performance Scripts

Mstat -- System Statistics /Tuning Script CR 106834 Script To Report The Instance Statistics CR 97900 Report Table's Rows Per Datafile CR 125123 Script To Provide Latch Performance Information CR 96728 Script To Report File I/O Statistics CR 135834 Script To Simplify The Use Of Explain Plan CR 135835 Script To Report Dictionary Cache Effectiveness CR 93729 Script To Report Sga Buffer Summary CR 96730 Report Session & System WaIts CR 125127 Report Statistics For A Table CR 125128 Rstat -- Reactive Performance Utility CR 103423 Script To Show Sga Parameters & Statistics CR 135844 Estimate Shared Pool Utilization CR 111787 Report Various Db Statistics CR 116488 Script To Check Tables For Statistics CR 135855 Create Stats For All Tables In Schema CR 135856 Formatted Select Of Explain Plan Table CR 135858

Privileges/Profiles Scripts

Script To Report Roles Granted To Users CR 95174 Script To Show System & Object Privs For User CR 121099 Report User Role And Profile Info CR 111785 Report Privs Granted To A User CR 116485 Create View To Show All User Privs CR 135861

Rollback Segments Scripts

Script For Displaying Active Transactions In Roll CR 95168 Script To Obtain Rollback Segment Information CR 95173 Script To Display Wrap Time For Rollback Segs CR 103421 Script for Creating Rollback Segments CR 58851

Space Management Scripts

Script To Move Sys.Aud$ Table Out Of System Table CR 135831 Script To Force Coalesce Of Contiguous Free Extents CR 95164 Script To Create Database Extents Summary CR 95166 Script To Create Tablespace Block Map CR 95172 Script To Show Table Extents & Storage Parameters CR 101492 Script To Report On Tablespace Storage Parameters CR 135832 Script To Calculate Table Row Size CR 101493 Script To Show Tables Which Cannot Extend CR 95179 Script To Remove Chained Rows From A Table CR 95181 Script To Calculate Blocks Needed By A Table CR 97898 Script To Report Tablespace Free And Fragmentation CR 97902 Script To Print Block Map Of Entire Database CR 100944 Script To Report Tablespace Use By Segment Type CR 99197 Script To Show Tablespace Use By User CR 100945 Script To Print Map Of All Database Files CR 135837 Script To Report Table Fragmentation CR 135838 Script For Data & Index Block Distribution CR 100946 Script To Report Segments in a Datafile CR 98901 Script To Report Tables Approaching Maxextents CR 97903 Script To Report On Segment Extents CR 120472 Script To Report Segment Storage Parameters CR 100948 Script To Report Users And # Of Objects In Tables CR 104477 Script To Show Extents For A Given Segment CR 104478 Script To Report # Of User Objects Per Tablespace CR 106839 Script To List Tablespace, Files And Free Space CR 135841 Check Tables For Backup Status CR 135842 Get Row Count For All Tables In A Schema CR 121101 Script To Report Free Space In Database CR 103424 Script To Report The Largest Segments In The Data CR 103425 Script To Report Tables Which Should Be Dropped CR 135846 Report Tables With Many Extents CR 135847 Report On Space In Tablespaces CR 124824 Script To Detect Tablespace Fragmentation CR 135852 User Segment/Extent Report CR 116487 Count How Many Of Each Object Users Have CR 135853 Report Db Space Usage By User CR 135854 Report Size Of Stored Objects CR 109916 Report Size Of Stored Objects CR 135862

Utility Scripts

Script For Decimal To Hexadecimal Conversion CR 97897 Script To Calculate Business Days Between Two Dat CR 100942 Convert Mm/Dd/Yyyy Hh:Mi:Ss To Redo Dump Time CR 108530 Convert Redo Dump Time To Mm/Dd/Yyyy Hh:Mi:Ss CR 108531 Determine Segment Order Of Columns CR 108533