Re: ** dictionary table access slow

From: zhu chao <chao_ping_at_vip.163.com>
Date: Sun, 22 Feb 2004 14:20:35 +0800
Message-ID: <000801c3f91f$2a3eb180$9a3b5fd3@chaos>

Hi,

I have seen similar problems before, 8172 on solaris 8. Ii was caused by the optimizer mode = first_rows in initsid.ora. Add +rule hint solved the problem. Check if you hit the same problem.

Regards

Zhu chao
----- Original Message -----
From: "Hemant K Chitale" <hkchital_at_singnet.com.sg> To: <oracle-l_at_freelists.org>
Sent: Sunday, February 15, 2004 10:05 PM Subject: Re: ** dictionary table access slow

>
> I prefer :
> select y.sql_text
> from v$session x, v$sqltext y, v$process q
> where x.sql_address = y.address
> and x.sql_hash_value = y.hash_value
> and q.addr = x.paddr
> and q.spid = &unix_pid --> when querying by Server ProcessID
> order by x.sid, y.piece
> /
>
> At 12:43 PM 11-02-04 -0800, you wrote:
> >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_at_freelists.org
> >put 'unsubscribe' in the subject line.
> >--
> >Archives are at http://www.freelists.org/archives/oracle-l/
> >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> >-----------------------------------------------------------------
>
> Hemant K Chitale
> Oracle 9i Database Administrator Certified Professional
> http://hkchital.tripod.com {last updated 24-Jan-04}
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun Feb 22 2004 - 02:35:20 CST