Re: Four free SQR utilites

[Shawn Dunn <sdunn@MIT.EDU>]

Hi,

Could I get a copy of UTIL.SQR and DB.SQR?

Thanks for offering.

Shawn

At 09:24 AM 12/19/97 +0300, you wrote:
>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
>
---------------------------------------------
Shawn Dunn - sdunn@mit.edu
Analyst/Programmer III - MIT Bursar's Office, Cambridge, MA
http://web.mit.edu/sdunn/www/