DB.SQR

This is actually a series of 15 or so reports about various database objects: Tables (including primary/foreign keys), indexes, views, sequences, snapshots, db triggers, stored procedures, etc. It also reports on objects with extents and chained-rows. Also a "search function" to locate which user an object belongs to and what is it (table, view, synonym, etc).

Notes: You need to run this in "system/manager". If Oracle doesn't recognize some of the tables, you may have to "grant select" those tables from "sys" to "system" (using SQLDBA).

History:

The 98/1/6 version includes scale and precision of NUMBER columns in the Table data dictionary report. Earlier versions did not include this information.
The 98/6/21 version stores constraint info using load-lookup to for faster performance.
The 99/8/18 version includes an additional report on Oracle database jobs and calculates KB correctly (dividing by 1024 instead of 1000).
The 00/12/14 version adds a report which shows which database objects are locked and by whom.

Contributed by Chanan Morrison, chananm@netvision.net.il.

Download DB.SQR.

Send comments and questions to the SQRUG Librarian.

Go to SQR Users Group Home Page.

File last modified 12-OCT-1998.