Riyaj, > Running this SQL from the sqlplus results in 11000 buffer gets >approximately, with a subsecond response. Luckily, We had >tracing on for >the duration of the test and grepping through the trace file I can see >that the above SQL was in 5 trace files with the OS PIDs: 8868, 8872, >8874, 8876 and 8880. Does this use MTS or PQ by any chance? >BTW, DB is 8.1.7.4 64 bit on Solaris 8. No special options >such as RAC.. John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** ---------------------------------------------------------------- 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 -----------------------------------------------------------------