Capturing sql statement

From: Arun Chugh <arun.chugh1610_at_gmail.com>
Date: Tue, 25 Sep 2018 22:31:23 +0530
Message-ID: <CAOyn3Gczrdu1nb9P4PXW0OXMo+JA3q9-4Zs++btSiTCHj0uO2w_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 25 2018 - 19:01:23 CEST

This message: [ Message body ]
Next message: Chris Taylor: "Re: Capturing sql statement"
Previous message: Seth Miller: "Re: Configuring a client TNS entry for TAF"
Next in thread: Chris Taylor: "Re: Capturing sql statement"
Reply: Chris Taylor: "Re: Capturing sql statement"
Reply: sachin pawar: "Re: Capturing sql statement"
Maybe reply: Jonathan Lewis: "Re: Capturing sql statement"
Reply: Karl Arao: "Re: Capturing sql statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message