This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,859 Users
  • 2,269,775 Discussions


Get list of SQL_ID between two Snapshot Id's

I have two Snap Id (Begin snapshot time- End snapshot time) query- SELECT snap_id FROM dba_hist_snapshot;

I want to get a list of all SQL_Ids executed between the two snapshots.

Is there any way to get the list of all SQL Ids?

In the Screenshot , I have a text field for SQL_ID. I want to make it a combo box, with values as SQL id's based on the begin and end snapshots.