Home » RDBMS Server » Performance Tuning » collect Plan
collect Plan [message #275135] Thu, 18 October 2007 08:10 Go to next message
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
Michel Cadot
Messages: 64152
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
Previous Topic: DB Block Buffer value
Next Topic: Optimizing specific client query
Goto Forum:
  


Current Time: Sat Dec 10 20:33:50 CST 2016

Total time taken to generate the page: 0.13936 seconds