you can get the SQL statement using SQL ID from v$sql view.
set long 10000
select sql_fulltext from v$sql where sql_id='SQL ID';
Alternately, you can generate awr report during that period to get the top sqls running that time.
There is rule of thump to consider addm recommendations. Any thing that is impacting database performance is candidate to tune / configure.
Thanks,




Reply With Quote