RE: ** dictionary table access slow
- From: Ravi Kulkarni <kulkarni.ravi@xxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 11 Feb 2004 14:57:25 -0600
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@xxxxxxxxx]
Sent: Wednesday, February 11, 2004 2:44 PM
To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
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.
---------------------------------
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
