OraFAQ Forum: Performance Tuning » Performance Tuning Tool

Home » RDBMS Server » Performance Tuning » Performance Tuning Tool

Wed, 04 August 2004 12:17

ron
Messages: 50
Registered: July 1999

Member

Does anyone�know of any SQL tuning tool that may be run by users not having access to the v$ tables?

Fri, 06 August 2004 02:57

Frank
Messages: 7901
Registered: March 2000

Senior Member

For tuning individual statements use dbms_xplan:

explain plan set statement_id = 'XPLAN_FRANK'
for
[insert statement here]
/

select *
from   table(dbms_xplan.display(null, 'XPLAN_FRANK'))
/

This works great in 9i.

hth

Previous Topic:	which is the best tool to analyse
Next Topic:	how to use index es in execution

Goto Forum:

]

Current Time: Fri Apr 19 22:50:51 CDT 2024