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@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 >----------------------------------------------------------------- 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@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 -----------------------------------------------------------------