Home » RDBMS Server » Performance Tuning » Parse And Executing Statements (Oracle 10.1.0.2.0,HP-UX B.11.23)
Parse And Executing Statements [message #414620] Thu, 23 July 2009 00:31 Go to next message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
Dear All,I have executed a query

SELECT PARSE_CALLS,EXECUTIONS,SQL_TEXT FROM v$sql
WHERE executions = 0 AND parse_calls > 0
ORDER BY parse_calls DESC
for which i m getting result set as
PARSE_CALLS EXECUTIONS SQL_TEXT
44 0 SELECT * FROM MAT_CD_RMHS
44 0 SELECT * FROM ZM_REC_DIS

So , i would like to know why these type of select queries get parsed and not executed.Cursor_sharing is exact here.Please list out the reason why it is parsed and not executed.Thnx in advance

Re: Parse And Executing Statements [message #414628 is a reply to message #414620] Thu, 23 July 2009 01:12 Go to previous message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are parsed because application asked them to do so.
They are not executed because application did not ask to be executed.

From one of your previous post:
Michel Cadot wrote on Thu, 16 April 2009 10:48
...
Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel


Previous Topic: Storage parameters..
Next Topic: SQL tuning
Goto Forum:
  


Current Time: Wed Dec 07 06:44:32 CST 2016

Total time taken to generate the page: 0.08501 seconds