sql

SELECT sql_id, sql_text

FROM v$sql

WHERE sql_text LIKE '%<search_keyword>%';

SELECT s.sid, s.serial#, s.username, s.sql_id, q.sql_text

FROM v$session s

JOIN v$sql q ON s.sql_id = q.sql_id

WHERE s.status = 'ACTIVE' AND s.username IS NOT NULL;

SELECT sql_id, executions, elapsed_time, buffer_gets, disk_reads

FROM v$sql

ORDER BY elapsed_time DESC FETCH FIRST 10 ROWS ONLY;

SELECT sql_id, hash_value, sql_text

FROM v$sql

ORDER BY sql_id;

SELECT sql_id, sql_text

FROM v$sql

WHERE sql_id = (SELECT sql_id FROM v$session WHERE sid = &sid);