Re: Four free SQR utilites

[Allan Geetter <geetter@UHAVAX.HARTFORD.EDU>]

Please, could all who would like copies of these utilities please request them
DIRECTLY from Shawn Dunn -  SDUNN@MIT.EDU?   This will free up messages coming
to all who are on this list.

Thank you,

Allan Geetter

Shawn Dunn wrote:

> 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/


begin:          vcard
fn:             Allan  Geetter
n:              Geetter;Allan
org:            University of Hartford
adr;dom:        200 Bloomfield Ave.;;Information Technology Services - CC125;West Hartford;Connecticut;06117-1599;
email;internet: geetter@uhavax.hartford.edu
title:          Data Security Administrator
tel;work:       (860) 768-4889
tel;fax:        (860) 768-4907
x-mozilla-cpt:  ;0
x-mozilla-html: TRUE
version:        2.1
end:            vcard