Home » RDBMS Server » Performance Tuning » Explain plan
Explain plan [message #221933] Thu, 01 March 2007 02:51 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hi

How to find explain plan for procedure. How to know the time taken by each sql in procedure.

Thanks inadvance
Re: Explain plan [message #221934 is a reply to message #221933] Thu, 01 March 2007 02:59 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/ex_plan.htm

regards
Taj
Previous Topic: Performance with materialized view
Next Topic: Alter Session (workareas and area_sizes)
Goto Forum:
  


Current Time: Sun Dec 04 06:47:12 CST 2016

Total time taken to generate the page: 0.07540 seconds