Ultimos comandos SQL executados

Para visualizar os comandos executados no oracle, basta consultar:

SELECT /*+ INDEX (c) INDEX (q) USE_NL (q) */
q.piece, q.sql_text
FROM v$open_cursor c, v$sqltext_with_newlines q
WHERE c.sid = &SID
AND c.”ADDRESS” = q.”ADDRESS”
AND c.”HASH_VALUE” = q.”HASH_VALUE”
ORDER BY q.”ADDRESS”, q.”HASH_VALUE”, q.piece