| Visual Explain [message #160129] |
Thu, 23 February 2006 07:32  |
theo06
Messages: 29
Registered: February 2006
|
Junior Member |
|
|
Hi,
I have an issue with optimizing / tuning RDBMSs. Afaik there are a lot of options to do that. My main interest is optimizing Oracle as well as DB2. So I found a tool named Visual Explain for DB2 Databases. This tool can analyze your sql and draw you an query plan. That's a nice way for finding failures in sql and indexes and so on.
My question now is, is there a similar tool for Oracle RDBMSs too?
Thank you in advance!
Theo
|
|
|
|
| Re: Visual Explain [message #160240 is a reply to message #160129] |
Fri, 24 February 2006 00:54  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
If you have Oracle Enterprise Manager (OEM) there is a nice Explain Plan in the SQL*Scratchpad tool. You can also view the plan for currently running SQLs in the SESSION window.
TOAD (downloadable off the Web) is also OK for explain plan.
_____________
Ross Leishman
|
|
|
|
| Re: Visual Explain [message #160286 is a reply to message #160129] |
Fri, 24 February 2006 05:10 |
suryaevl
Messages: 8
Registered: October 2005
Location: Chennai
|
Junior Member |
|
|
Apart from TOAD there are more tools available.
Some of the excellent tools are
1. SQL Navigator
2. Spot light on Oracle
The Spot light gives out a entire picture DB in a
graphical format considering every corner of DB.
But it is costlier.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
