Parse And Executing Statements [message #414620] |
Thu, 23 July 2009 00:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|
|