Tuning Oracle

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