What queries are running?
COLUMN userID FORMAT A14
COLUMN sql_text FORMAT A65
BREAK ON userID SKIP 2
SET pagesize 0
SELECT s.schemaname||'('||TO_CHAR (s.sid)||')' userID,t.sql_text
FROM sys.v$session s,sys.v$sqltext t
WHERE t.address = s.sql_address
ORDER BY s.sid,t.piece
/
just disk reads & sql
SELECT disk_reads, executions, sql_text
FROM v$sqlarea;
cassandracle - shows disk reads
select sql_text, disk_reads, loads, optimizer_cost, parsing_user_id, serializable_aborts, au.username
from v$sql, all_users au
where disk_reads > 10000
and parsing_user_id = au.user_id
order by disk_reads desc;
Tablespace monitoring
SELECT a.tablespace_name, a.total, b.used
FROM (SELECT tablespace_name, SUM (bytes) total
FROM dba_data_files
GROUP BY tablespace_name) a,
(SELECT tablespace_name, SUM (bytes) used FROM dba_segments
GROUP BY tablespace_name) b
WHERE a.tablespace_name = b.tablespace_name (+)
/
2004
