Home » RDBMS Server » Performance Tuning » about V$SQL ......
about V$SQL ...... [message #557065] Fri, 08 June 2012 10:18 Go to next message
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"?
Re: about V$SQL ...... [message #557066 is a reply to message #557065] Fri, 08 June 2012 10:26 Go to previous messageGo to next message
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/
Re: about V$SQL ...... [message #557068 is a reply to message #557065] Fri, 08 June 2012 10:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give us your opinion.
For instance, when a sql is parsed?

Regards
Michel
Re: about V$SQL ...... [message #557076 is a reply to message #557068] Fri, 08 June 2012 11:43 Go to previous messageGo to next message
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 .
Re: about V$SQL ...... [message #557080 is a reply to message #557076] Fri, 08 June 2012 12:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you answer the question "when a sql statement is parsed?"?
Hint: Database Concepts.

Regards
Michel

Re: about V$SQL ...... [message #557103 is a reply to message #557080] Fri, 08 June 2012 20:51 Go to previous message
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
Previous Topic: how to reduce the clustering_factor's value?
Next Topic: Performace issue in transaction system
Goto Forum:
  


Current Time: Thu Mar 28 09:16:48 CDT 2024