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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 04:38:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.