Re: Four free SQR utilities

[Randle Boyd <rboyd@RUAN.COM>]

I would be interested in UTIL.SQR and DB.SQR

TIA,
Randle

>----------
>From:  Chanan & Gaila Morrison[SMTP:chananm@NETVISION.NET.IL]
>Sent:  Friday, December 19, 1997 12:24 AM
>To:    Multiple recipients of list SQR-USERS
>Subject:       Four free SQR utilites
>
>For all who are interested:
>
>We find  the following SQR utilities quite useful. They are without charge,
>and without responsibilty. They are all SQR programs themselves, so that
>they should run no matter what computer you have, but in fact I have only
>used them on UNIX machines.
>
>1. UTIL.SQR - this utility has 2 main functions: a formatter to "beautify"
>a program, and a "trace" function which creates a version of your program
>which sends out a message at the beginning of each procedure. (I find it
>useful when I want to quickly pinpoint which "select" is bogging down a
>large report).
>
>The other utilities are specific to Oracle v. 7:
>
>2. 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).
>
>3. CRE_IND.SQR - this program creates an SQL script which will recreate
>indexes. It knows how to deal with primary keys. May be run for a specific
>index, all indexes of a table, or all indexes in a User. It calculates the
>storage parameters according to current usage. Useful for recreating
>indexes with many extents, or indexes in the wrong tablespace.
>
>4. DBA.SQR - this is a performance report of various aspects of the
>database. Mainly of interest to DBAs.
>
>If you are interested in any of these programs, send a message to
>chananm@netvision.net.il and specify which one(s). I tried posting them to
>the SQRUG web site, but either they didn't make the grade or the code
>librarian is too busy.
>
>Chanan Morrison
>