Re: Slow log

From: Mladen Gogala <>
Date: 11 May 2008 18:29:27 GMT
Message-ID: <48273b07$0$6432$>

On Sat, 10 May 2008 18:15:00 -0700, iavian wrote:

> How to log all the queries that takes more than n seconds .. like mysql
> show query log

FGA (fine-grained auditing) might be helpful. Also, you may write a script that will query V$SQL and extract SQL by the elapsed time. However, querying that table hits the library cache latch every time. Don't do it too often.

Mladen Gogala
Received on Sun May 11 2008 - 13:29:27 CDT

Original text of this message