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.
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.
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
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
Its TOAD for me...
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.
This stuff rocks!
Originally Posted by Orca777
Click Here to Expand Forum to Full Width