HI all,
11.2.0.1
I want to get the SQL TEXT of the blocker program.
Based on the ADDMRPT it mentioned that:
The session with ID 9 and serial number 15 in instance number 1 was the
blocking session responsible for 100% of this recommendation's benefit.
So I select the row from DBA_HIST_ACTIVE_SESS_HISTORY using:
SQL> select sql_id from dba_hist_active_sess_history where session_id=9 and session_serial#=15;
SQL_ID
-------------
fn3qv2dhsu3nb
Then I selected the row from DBA_HIST_SQLTEXT using:
SQL> select * from dba_hist_sqltext where sql_id='fn3qv2dhsu3nb';
no rows selected
Why is it not found?
Thanks,
zxy