OraFAQ Forum: Performance Tuning » Doubt on "SQL Ordered by Parse Calls"

Home » RDBMS Server » Performance Tuning » Doubt on "SQL Ordered by Parse Calls"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Doubt on "SQL Ordered by Parse Calls" [message #222900]

Tue, 06 March 2007 21:51

gkodakalla
Messages: 49
Registered: March 2005

Member

Hi,
in the snapshot i generated for a database, i found the section as follows for "SQL ordered by Parse Calls".

SQL ordered by Parse Calls
-> Total Parse Calls: 634,128
-> Captured SQL account for 72.3% of Total

% Total
Parse Calls Executions Parses SQL Id
------------ ------------ --------- -------------
44,441 44,441 7.01 fzxphbq4df76h
.
.
.

I found all the records mentioned in that report have same number for Parse calls and for Executions. Is it okay if we have the number same for "Parse calls" and "Executions". Is it not required to have less parse calls and more executions for a given statement.

Thanks.

Report message to a moderator

Re: Doubt on "SQL Ordered by Parse Calls" [message #222901 is a reply to message #222900]

Tue, 06 March 2007 22:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is it not required to have less parse calls and more executions for a given statement.
Obviously it is NOT required because they are equal in your case.

Report message to a moderator

Re: Doubt on "SQL Ordered by Parse Calls" [message #222907 is a reply to message #222900]

Tue, 06 March 2007 23:10

gkodakalla
Messages: 49
Registered: March 2005

Member

But will this have any impact on soft parse %? For this system, soft parse %age is only 88% now.

What i wanted to know is, if we have the parse count and execution count as same, we are parsing for every execution.
Will it hit performance of the system? Is it not required to have less parses than executions?

Thanks

Report message to a moderator

Re: Doubt on "SQL Ordered by Parse Calls" [message #222910 is a reply to message #222900]

Tue, 06 March 2007 23:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>What i wanted to know is, if we have the parse count and execution count as same, we are parsing for every execution.
Yes, 1 parse for every execution.

>Will it hit performance of the system?
Every system will eventually hit performance limit.
When doing 1 parse for every execution, you hit the limit sooner that when having only 1 parse for MANY executions.

>Is it not required to have less parses than executions?
Obviously it is NOT required because they are equal in your case.

It is desired to have parses < executions; but not REQUIRED.

Report message to a moderator

Re: Doubt on "SQL Ordered by Parse Calls" [message #222947 is a reply to message #222900]

Wed, 07 March 2007 00:48

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

There are a number of articles by Tom Kyte (look at google) about performance problems caused by soft parsing.
In your case your application is either using Java/.Net and closes the statement each time or generates dynamic sql and releases the cursor from session-level cache which is not desirable in both cases.

Report message to a moderator

Previous Topic:	Tunned querry
Next Topic:	performance of a query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 08 06:00:28 CDT 2025