collect Plan [message #275135] |
Thu, 18 October 2007 08:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 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
|
|
|