by Mladen Gogala <mgogala@[EMAIL PROTECTED]
>
May 11, 2008 at 06:29 PM
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.com
