query v$sqlarea very slow

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. Received on Wed Nov 22 2000 - 18:31:02 CST