| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ** dictionary table access slow
Are you using LMTs ? We had a similar issue but it cleared when DMTs
were converted to Local.
fet$,uet$ etc etc were huge due to mismanaged extent sizes.
Thanks,
Ravi.
-----Original Message-----
From: A Joshi [mailto:ajoshi977_at_yahoo.com]
Sent: Wednesday, February 11, 2004 2:44 PM
To: oracle-l_at_freelists.org; oracledba_at_lazydba.com
Subject: ** dictionary table access slow
Hi,
Queries to v$ tables are taking too long. We have Sun UNIX with 8174. For example the following queries take around 1 minute. How can this be tuned. Is it a symptom of some other problem? :
select a.sid, a.serial#, c.spid, a.username, a.osuser,
a.status,a.process, b.sql_text
from v$session a , v$sqlarea b, v$process c
where a.sql_address = b.address
and c.addr = a.paddr
order by a.username, a.osuser
Thanks. Help is appreciated.
 |
 |