Supply the sql_id and the SQL will be recorded in the AWR even if it doesn't meet any of the limits set for normal "SQL ordered by ... "
There's a limit of 100 sql_ids that can be "colored" - then you get error:
ORA-13534: Current SQL count(100) reached maximum allowed (100)
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 751
dbms_workload_repository.remove_colored_sql() to remove them from the hit list
From: firstname.lastname@example.org <email@example.com> on behalf of Arun Chugh <***@gmail.com>
Sent: 25 September 2018 18:01
To: Oracle Mailing List
Subject: Capturing sql statement
I have one scenario related to capturing of sql statement in history table.. Like dba_hist_sqltext capture the queries that ran for 10 sec or more.. How do I get the sql stmt which took less time say in millisecond.. Any idea pleae share.