Showing posts with label TOP 10 SQL STATEMENTS WITH LARGE NO. OF DISK READS. Show all posts
Showing posts with label TOP 10 SQL STATEMENTS WITH LARGE NO. OF DISK READS. Show all posts

Monday, 14 May 2018

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;

Add Data file

 ************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...