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.

 

[SantaMufasa]

Migreen,

24 hours with no responses on Tek-Tips generally means, "No" to whatever the question is; I am not aware of such a nice tool. That also means it smells like a "business opportunity" for anyone willing to "pick up the gauntlet" .

Mufasa
(aka Dave of Sandy, Utah, USA @ 16:11 (15Oct04) UTC (aka "GMT" and "Zulu"), 09:11 (15Oct04) Mountain Time)