Oracle Best Practices

[migreen]

Hello,

I am a database performance analyst which means I work with a large number of RDBMS packages. Lately I have worked with MSSQL but a new project has brought me back to my first love, Oracle.

Currently, Microsoft has a product called “Microsoft SQL Server 2000 Best Practices Analyzer” which once activated allows a user to select form a set of predefined “rules” for best practices and search the database for compliance or as often is the case with .Net developers, non-compliance.

Some of the basic rules search for things like the presence of ‘SELECT *’ in a Stored Procedure or the lack of a defined Primary Key.

Does anyone know of a product which performs this for Oracle systems? I could spend weeks, even months calling through the database looking for design issues but I usually don’t have that kind of time. I need something that will spot the blatant offenders and allow me to couple my analysis with a good helping of SQL Trace output.

Any help or suggestions would be greatly appreciated.

 

[Turkbear]

Hi,
Try TOAD from Quest software
(

http://www.quests.com/toad/)

It has, as part of its DBA module, a 'Health Check' that looks at many areas of your Instance..
It is a very useful tool for Oracle DBA and developers..

( I am not now, nor have I ever been, connected to this company, so I hope this does not violate the forum rules..)