Capturing all the SQLs ran yesterday

[tamilselvan]

When the system is running slow, run the following the query to capture the SQL statement and then do EXPLAIN PLAN.

Replace SCOTT with your user name.

select sql_text from sys.v$sqltext_with_newlines
where (address, hash_value ) in
( select sql_address, sql_hash_value
from v$session where username in ('SCOTT')
)
order by address, piece;