gridcontrol views used for extracts higher activity sessions
hi , please I need to get the session that generates increased activity or increased consumption at a given moment , I've tried with this statement
SELECT sql_text, parsing_schema_name FROM V$sqlarea WHERE last_active_TIME>=sysdate-5/8640 and
last_active_TIME<=sysdate
order by disk_reads/decode(executions,0,1,executions) desc
which should be able to determine the most active session in a range of 5 min, however, the results do not match the result of the grid control, please,
could someone tell me gridcontrol views used to display these graphics, as well as the top sentences for a given interval
SELECT sql_text, parsing_schema_name FROM V$sqlarea WHERE last_active_TIME>=sysdate-5/8640 and
last_active_TIME<=sysdate
order by disk_reads/decode(executions,0,1,executions) desc
which should be able to determine the most active session in a range of 5 min, however, the results do not match the result of the grid control, please,
could someone tell me gridcontrol views used to display these graphics, as well as the top sentences for a given interval
0