Re: Slow log
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 11 May 2008 18:29:27 GMT
Message-ID: <48273b07$0$6432$834e42db@reader.greatnowhere.com>
Date: 11 May 2008 18:29:27 GMT
Message-ID: <48273b07$0$6432$834e42db@reader.greatnowhere.com>
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 http://mgogala.freehostia.comReceived on Sun May 11 2008 - 13:29:27 CDT