Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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?
test1.pngIn 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.

Comments
Post Details
Added on Jan 10 2023
1 comment
1,589 views