Hi,
From one of our databases:
select parse_calls, executions, buffer_gets, elapsed_time from v$sql
2 where sql_text like '%SELECT COUNT(DISTINCT(DISPLAY_FLAG)) FROM <table>%' ;
PARSE_CALLS EXECUTIONS BUFFER_GETS ELAPSED_TIME
------------ ------------ ------------ ------------
11,533 11,533 80,731 3460981
35,167 35,167 246,169 11088514
21,288 21,288 149,016 6712950
..
oracle 11.2, 2 node rac. instance last bounced 10 days ago;
no where clause in the query.
This is an application used company wide. I see the number of parse calls and the executions are same, can this be considered an application issue?
F.