You can use v$sql to write custom pl/sql job
On Tue, Sep 25, 2018 at 1:02 PM Arun Chugh <arun.chugh1610@xxxxxxxxx> wrote:
--
All,
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.
Regards,
Arun Chugh