Database 11g

Tuesday, October 27, 2015

TOP 10 SQL STATEMENTS WITH LARGE NO. OF DISK READS


set pagesize 1000
col username format a10
col terminal format a10
col program format a15
col sql_text format a30
select a.username, a.terminal, a.program,b.sql_text from v$session a, v$sqltext b where a.sql_hash_value = b.hash_value;


No comments:

Post a Comment