db file scattered read

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Fri, 06 Aug 2004 16:07:56 -0700
Message-Id: <200408062307.i76N7uNX001915@rm-rstar.sfu.ca>

Hello,

Could use some help here.

If database statspack report says that the event:

"db file scattered read" is the top wait event and it uses up a large proportion of the time between each statspack.snap snapshots, what does this mean?

Thanks for any tips and suggestions.

--

Lyndon Tiu

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Aug 06 2004 - 18:03:47 CDT