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

Report message to a moderator

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: 68664
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

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jun 24 07:56:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.