Re: File open wait

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 20 Jan 2006 19:06:03 -0600
Message-ID: <018501c61e27$3df545c0$9fbc21c8@porgand>

RE: File open waitLuis,

Did you verify that your v$session.state says WAITING, not just WAITED? Because WAITED doesn't mean that your session is waiting.

Otherwise compare the SQL execution plans and number of logical IOs+CPU usage (as John said) for the executed SQL statements for both "fast" and "slow" environments.

Tanel.

Original Message ----- From: Luis Fernando Cerri To: john.kanagaraj_at_hds.com ; tanel.poder.003_at_mail.ee ; ORACLE-L Sent: Friday, January 20, 2006 6:15 PM Subject: RE: File open wait

Hi Tanel, John, Raj, Millsap and others following this thread.

I gonna give you some news regarding the issue.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 20 2006 - 19:06:03 CST