Vivek, I had a tar open with Oracle on undue high time for 'global cache cr request' wait ... So have you opened a tar yet? Raj ------------------------------------------------------------------------ --------=20 Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 select standard_disclaimer from company_requirements;=20 QOTD: Any clod can have facts, having an opinion is an art ! -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of K Gopalakrishnan Sent: Wednesday, April 21, 2004 11:20 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: SQL Trace Qs.=20 --- VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote: > Folks >=20 > What could be the Cause for HIGH Value of elapsed time=3D3D3.27 in the = > following SELECT Queries? >=20 > NOTE - It is doing a UNIQUE Index Scan=3D20 >=20 > Will provide any info required >=20 > 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 -----------------------------------------------------------------