What is the optimiser mode set to? If it is set to first_rows this could be the cause - try altering the mode at session level or as others have said, rule hint / check for analysed sys objects HTH, Bruce Reardon mailto:bruce.reardon@xxxxxxxxxxxxxxxxxxxxxxx =20 NOTICE: This e-mail and any attachments are private and confidential and = may contain legally privileged information. If you are not an = authorised recipient, the copying or distribution of this e-mail and any = attachments is prohibited and you must not read, print or act in = reliance on this e-mail or attachments. This notice should not be = removed. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hemant K Chitale Sent: Monday, 16 February 2004 1:06 AM To: oracle-l@xxxxxxxxxxxxx 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 =3D y.address and x.sql_hash_value =3D y.hash_value and q.addr =3D x.paddr and q.spid =3D &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.=20 > For example the following queries take around 1 minute. How can this = be=20 > tuned. Is it a symptom of some other problem? : > >select a.sid, a.serial#, c.spid, a.username, a.osuser, = a.status,a.process,=20 >b.sql_text >from v$session a , v$sqlarea b, v$process c >where a.sql_address =3D b.address >and c.addr =3D a.paddr >order by a.username, a.osuser > >Thanks. Help is appreciated. ---------------------------------------------------------------- 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 -----------------------------------------------------------------