| collect Plan [message #275135] |
Thu, 18 October 2007 08:10  |
Majaa
Messages: 5
Registered: May 2007
Location: Tamilnadu
|
Junior Member |
|
|
I want to collect the plans for queries inside the PLSQL block .
Please let me know How to get plan inside plsql code ? Shall we use "EXPLAIN PLAN " commmand inside plsql block ?
[Updated on: Thu, 18 October 2007 08:10] Report message to a moderator |
|
|
|
| Re: collect Plan [message #275136 is a reply to message #275135] |
Thu, 18 October 2007 08:16  |
 |
Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Activate a trace (alter session set sql_trace=true) and analyze this trace using tkprof.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
