| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Waits
What are these queries waiting on? Did you run a 10046 trace?
-----Original Message-----
From: Seema Singh [mailto:oracledbam_at_hotmail.com]
Sent: Friday, July 22, 2005 2:50 PM
To: Reidy, Ron; oracle-l_at_freelists.org
Subject: RE: Waits
Most of time couple of queries are hanging!
>From: "Reidy, Ron" <Ron.Reidy_at_arraybiopharma.com>
>To: <oracledbam_at_hotmail.com>, <oracle-l_at_freelists.org>
>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_at_freelists.org
>[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh
>Sent: Friday, July 22, 2005 2:26 PM
>To: oracle-l_at_freelists.org
>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
>
>
>--
>http://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.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 22 2005 - 15:59:11 CDT
 |
 |