Re: Capturing sql statement
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 25 Sep 2018 22:13:59 -0400
Message-ID: <41fc9fd1-540e-0193-bbd9-f5fa8a724de9_at_gmail.com>
Date: Tue, 25 Sep 2018 22:13:59 -0400
Message-ID: <41fc9fd1-540e-0193-bbd9-f5fa8a724de9_at_gmail.com>
Or use fine grained auditing. That's what it is meant for.
On 09/25/2018 01:42 PM, sachin pawar wrote:
> 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
> <mailto: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
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 26 2018 - 04:13:59 CEST