Home » RDBMS Server » Performance Tuning » execution plan for a stored procedure
icon5.gif  execution plan for a stored procedure [message #250990] Thu, 12 July 2007 02:25 Go to next message
steve_kc
Messages: 5
Registered: July 2007
Location: Malaysia
Junior Member
How to create exexution plan for stored and procedure using sql plus??

Thanks
Re: execution plan for a stored procedure [message #251011 is a reply to message #250990] Thu, 12 July 2007 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
There is no plan for PL/SQL only for SQL.

Regards
Michel
Re: execution plan for a stored procedure [message #251043 is a reply to message #250990] Thu, 12 July 2007 04:46 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
In terms of analyzing the execution of PL/SQL, you may want to consider DBMS_PROFILER.
Previous Topic: How Oracle using SAMPLE Clause on statistics?
Next Topic: ORA-1652: unable to extend temp segment by 16 in TEMP TS
Goto Forum:
  


Current Time: Sat Dec 03 01:22:28 CST 2016

Total time taken to generate the page: 0.14257 seconds