Oracle DB version: 19.13
Is there a way to find the queries (SQL IDs) that took more than 15 minutes to execute between 10 am and 11 am for a particular date ?
I mean, for a recent date like today or yesterday.
Its a 2-node RAC DB, but applications connect to the DB via custom services (singleton)