SQL Performance (MOSC)

MOSC Banner

unable to find long running sql_id in dba_hist_reports

edited Jan 20, 2019 4:08AM in SQL Performance (MOSC) 2 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center