SQL with more parse [message #524848] |
Tue, 27 September 2011 04:01 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
SELECT SQL_TEXT, PARSE_CALLS, EXECUTIONS FROM V$SQLAREA where rownum < 5 ORDER BY PARSE_CALLS desc;
select
sql_text,
parse_calls,
executions,
parse_calls/executions "Ratio",
loaded_versions
from
v$sql
where
parsing_user_id !=0
and
parse_calls > 500
and
executions > 500
and
rownum < 5
order by 2 desc;
Can somebody tel me why two queries return different results/different queries .
|
|
|
|
|
|
Re: SQL with more parse [message #524874 is a reply to message #524872] |
Tue, 27 September 2011 04:38 |
gkrishn
Messages: 506 Registered: December 2005 Location: Putty a dark screen
|
Senior Member |
|
|
both are order by "parse_calls" . and top in the output are parse_calls of 2000+ . so i was expecting both to return same results.Can someone give some "details" on whats wrong here.
|
|
|
|
|