Re: Slow log
Date: 11 May 2008 18:29:27 GMT
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