Re: query v$sqlarea very slow

susana73_at_hotmail.com wrote:
>
> I have a query below to check all the user's sql and it is
> extremelyslow. It takes couple minutes to run.
>
> select username, sql_text from v$session a, v$sqlarea b
> where a.prev_sql_addr=b.address;
>
> I discovered that the cause is v$sqlarea. It takes couple minutes just
> to do a count(*) of v$sqlarea. There are only about 10k rows in
> v$sqlarea. Anyone knows what happen? Anyway to improve the query?
>
> Thanks in advance.
>
> Susan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

It contains a GROUP BY. Try using V$SQL instead..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"