Home » RDBMS Server » Performance Tuning » collect Plan
collect Plan [message #275135] Thu, 18 October 2007 08:10 Go to next message
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: 65144
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.

Previous Topic: DB Block Buffer value
Next Topic: why ESTD_PHYSICAL_READS and ESTD_PHYSICAL_READ_TIME are not change in proportional in v$db_cache_a
Goto Forum:

Current Time: Sun Aug 20 03:04:32 CDT 2017

Total time taken to generate the page: 0.10620 seconds