Re: Capturing sql statement
From: sachin pawar <getsach_at_gmail.com>
Date: Tue, 25 Sep 2018 13:42:15 -0400
Message-ID: <CAA_xQWp2ZWFs4S8a1po5tTeaRa=ZWgJ_0JRVgDvpfhit0316ig_at_mail.gmail.com>
Date: Tue, 25 Sep 2018 13:42:15 -0400
Message-ID: <CAA_xQWp2ZWFs4S8a1po5tTeaRa=ZWgJ_0JRVgDvpfhit0316ig_at_mail.gmail.com>
You can use v$sql to write custom pl/sql job
On Tue, Sep 25, 2018 at 1:02 PM Arun Chugh <arun.chugh1610_at_gmail.com> 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
>
--
Rgds,
Sachin Pawar
https://twitter.com/sach_pwr
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 25 2018 - 19:42:15 CEST