RE: Waits
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: "Seema Singh" <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 22 Jul 2005 14:54:12 -0600
What are these queries waiting on? Did you run a 10046 trace?
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Seema Singh [mailto:oracledbam@xxxxxxxxxxx]
Sent: Friday, July 22, 2005 2:50 PM
To: Reidy, Ron; oracle-l@xxxxxxxxxxxxx
Subject: RE: Waits
Most of time couple of queries are hanging!
>From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
>To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
>Subject: RE: Waits Date: Fri, 22 Jul 2005 14:28:12 -0600
>
>What is the problem?
>
>-----------------
>Ron Reidy
>Lead DBA
>Array BioPharma, Inc.
>
>
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
>Sent: Friday, July 22, 2005 2:26 PM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: Waits
>
>
>Hi,
>
>On oracle9i with window XP ,I have been noticing following waits.
>Event Waits Time (s) Ela
>Time
>-------------------------------------------- ------------ -----------
>--------
>buffer busy waits 7,457,445 27,375
>65.17
>db file sequential read 1,243,050 11,924
>28.39
>
>Please suggest what to do?
>thanks
>
>
>--
>//www.freelists.org/webpage/oracle-l
>
>This electronic message transmission is a PRIVATE communication which
>contains
>information which may be confidential or privileged. The information is
>intended
>to be for the use of the individual or entity named above. If you are not
>the
>intended recipient, please be aware that any disclosure, copying,
>distribution
>or use of the contents of this information is prohibited. Please notify the
>sender of the delivery error by replying to this message, or notify us by
>telephone (877-633-2436, ext. 0), and then delete it from your system.
>
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
