PL/SQL Development tools

I would like to find a PL/SQL development tool that will help my developers analyze their code. For example, if they create a package called "DO_IT" with method "NOW", I want them to be able to do some initial analysis on DO_IT.NOW without DBA intervention. I would like a GUI tool that has some intelligence built in that will tell them if a query is poor (explain plan), runs a tkprof type trace, and has a pl/sql step debugger. Ideally, I'd like this tool to run on Solaris, but can run on Windoz if necessary.

Any ideas?

Check out www.globecom.se/tora

TOra - Toolkit for Oracle

I use the RH Linux version and am very impressed. It has a ton of features that'll just blow you away. Their alpha/beta versions seem to be very stable on release. No problems there.

Here's a user's quote from their page:

It's AWESOME! I'm a developer for a company who uses oracle a lot, but being Solaris based, haven't really had any nice tools to use. TOra, even in this pre1.0 form is sooooo cool. At last I can stop using sqlplus! I've already got about 10 people using it, and more are sure to follow...once I tell them about it.
Richard Sheldon

tora == toad

for pl/sql you could try embarcadero sql profiler or sql tuner, pl/sql developer, toad's debugger is pretty good as well

Hi,
Take PL/SQL-Developer http://www.allroundautomations.com/
You can get five licences for the price of one TOAD.

And you get my absolutly favourite PL/SQL-Tool

Orca
:cool:

Im up for TOAD from quest. Next is Procedure Builder that comes with Oracle Developer- a sod to use but allows step-by-step running through code on the server with break-points etc.

Quote:

---

Originally Posted by Orca777

Hi,
Take PL/SQL-Developer http://www.allroundautomations.com/
You can get five licences for the price of one TOAD.

And you get my absolutly favourite PL/SQL-Tool

Orca
:cool:

---

This stuff rocks!