OraFAQ Forum: Performance Tuning » about V$SQL ......

Home » RDBMS Server » Performance Tuning » about V$SQL ......

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

about V$SQL ...... [message #557065]

Fri, 08 June 2012 10:18

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

Hi, all.
In V$SQL view, when the column "PARSE_CALLS" > column "EXECUTIONS"?
when the column "PARSE_CALLS" = column "EXECUTIONS"?
when the column "PARSE_CALLS" < column "EXECUTIONS"?

Report message to a moderator

Re: about V$SQL ...... [message #557066 is a reply to message #557065]

Fri, 08 June 2012 10:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: about V$SQL ...... [message #557068 is a reply to message #557065]

Fri, 08 June 2012 10:32

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Give us your opinion.
For instance, when a sql is parsed?

Regards
Michel

Report message to a moderator

Re: about V$SQL ...... [message #557076 is a reply to message #557068]

Fri, 08 June 2012 11:43

lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China

Member

sorry ,i have no opinion.

i just want to know what's the relationship between PARSE_CALLS and EXECUTIONS .

Report message to a moderator

Re: about V$SQL ...... [message #557080 is a reply to message #557076]

Fri, 08 June 2012 12:28

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Can you answer the question "when a sql statement is parsed?"?
Hint: Database Concepts.

Regards
Michel

Report message to a moderator

Re: about V$SQL ...... [message #557103 is a reply to message #557080]

Fri, 08 June 2012 20:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i just want to know what's the relationship between PARSE_CALLS and EXECUTIONS .
It depends

Report message to a moderator

Previous Topic:	how to reduce the clustering_factor's value?
Next Topic:	Performace issue in transaction system

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 05 02:47:25 CDT 2025