Vivek: Is that a RAC environment? Can you post the relavant parts from the RAW trace file? KG --- VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote: > Folks > > What could be the Cause for HIGH Value of elapsed time=3D3.27 in the > following SELECT Queries? > > NOTE - It is doing a UNIQUE Index Scan=20 > > Will provide any info required > > Thanks > ---------------------------------------------------------------- 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 -----------------------------------------------------------------