TOP SQLs & TableSpace Free

TOP sqls :

set linesize 1000

set pagesize 1000

col sql for a50

SELECT sql,buffer_gets, executions

FROM (SELECT hash_value,address,substr(sql_text,1,40) sql,

            buffer_gets, executions, buffer_gets/executions "Gets/Exec"

      FROM V$SQLAREA

      WHERE buffer_gets > 100000 AND executions > 10

      ORDER BY buffer_gets DESC)

      WHERE rownum <= 5

/

Tablespace Free and Fragmentation [ID 1019709.6]

select
  total.tablespace_name                       tsname,
  count(free.bytes)                           nfrags,
  nvl(max(free.bytes)/1024,0)                 mxfrag,
  total.bytes/1024                            totsiz,
  nvl(sum(free.bytes)/1024,0)                 avasiz,
  (1-nvl(sum(free.bytes),0)/total.bytes)*100  pctusd
from
  dba_data_files  total,
  dba_free_space  free
where
  total.tablespace_name = free.tablespace_name(+)
  and total.file_id=free.file_id(+)
group by
  total.tablespace_name,
  total.bytes
/

set linesize 1000

set pagesize 1000