SELECT name||' = '||value parameter_info FROM v$parameter WHERE isdefault = 'FALSE' ; => v$parameter Query Output SELECT sid, seq#, event, wait_time, seconds_in_wait, DECODE(p1text, NULL, NULL, p1text||' = '|| p1)|| DECODE(p2text, NULL, NULL, '; '||p2text||' = '|| p2)|| DECODE(p3text, NULL, NULL, '; '||p3text||' = '|| p3) parameter_values FROM v$session_wait WHERE event NOT IN ( 'pmon timer','smon timer','WMON goes to sleep', 'rdbms ipc message', 'SQL*Net message from client' ); => v$session_wait Query Output SELECT s.sid, s.last_call_et, t.sql_text FROM v$session s INNER JOIN v$sqltext t ON s.sql_address = t.address WHERE s.status = 'ACTIVE' AND s.username IS NOT NULL ; => v$session, v$sqltext Query Output -- Diagnostic Alert Information SELECT * FROM v$diag_alert_ext ORDER BY indx;
17274