unable to find long running sql_id in dba_hist_reports
Hello All,
We had a loading job..that calls a specific package(BEGIN client.pkg_aim_b4_import.p_batch_aim_b4(:1 ); END;).The package has a sql_id and thousands of subprograms/sqls and when i was monitoring it in sql_monitor i was able to see the activity% of all queries in the package's sql_id.
It ran for one whole day and the job completed successfully.Today i was trying to query dba_hist_reports to take another sql monitoring report of the same query mentioned above with its sql_id.But was surprised to see that it was not part of the view.