Re: Four free SQR utilites

[Wendy Stern <wstern@NUI.COM>]

> Chanan,
    Could I get a copy too?
        Wendy
wstern@nui.com

> ----------
> From:         Chanan & Gaila Morrison[SMTP:chananm@NETVISION.NET.IL]
> Sent:         Friday, December 19, 1997 1: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
>