Re: Oracle 7 analyser

With all due respect, analysis of database design is a job for a human (at this time). And, since all but Oracle 7.3.4 are now desupported, I wouldn't bother trying to do anything with Oracle7 if I could avoid it. Oracle9i is already released - if possible try to get up to Oracle8i Release 3 (8.1.7) as that will be supported for a couple of years.

I suspect you are not after checking the design, but rather the implementation (admin & maintenance stuff) like which indexes are good/bad, disk allocation, memory allocation, etc.

That said, check out Oracle Press - they have a recent book on using StatsPack (StatsPack is part of Oracle8i but it does work against Oracle 7, sort of - caveats in the book). (Oracle Press can be accessed from Technet - http://technet.oracle.com

HTH
/Hans

Daniel Vaughan wrote:

> Can anyone recommend any database analyser products for Oracle 7,
> specifically to analyise how well the database has been designed and any
> potential problems.
>
> Regards
>
> Daniel Vaughan
>
> Senior Technical Consultant
> K-solutions Limited
> www.k-solutions.com
>
> Reg No: 3636882 a member company of Avant Holdings Limited
>
> ----------------------- Important Notice -----------------------
> This email is from an Avant Holdings Limited Company. The information in
> this email and any files transmitted with it are confidential and may be
> legally privileged. It is intended solely for the addressee. Access to this
> email by anyone else is unauthorised.
>
> If you are not the intended recipient, any disclosure, copying, distribution
> or any action taken or omitted to be taken in reliance on it, is prohibited
> and may be unlawful.
>
> If you have received this email in error please notify Avant Holdings
> Limited Company using the email address info_at_k-solutions.com or by telephone
> on 07000 576588.
>
> Views or opinions expressed by an individual within this email may not
> necessarily reflect the views of Avant Holdings Ltd.
>
> ------------------- End Important Notice ---------------------
Received on Sat Jul 21 2001 - 23:57:48 CEST