| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> db file sequential reads
Hi all,
We have SAP application runing on a machine and Oracle 8.1.6.2 instance on
an other, the two machines
are connected to a gigabyte network. time response of the requests from SAP
to Oracle is
very long. We investigated with utlbstat and utlestat and we found that
we have too much waits on "db file sequential reads" (85% of the active
waits)
No disk I/O problem is detected.
Buffer cache hit_ratio = 92.30 %
Is it normal to have such amount of waits on "db file sequential reads" ?
SVRMGR> select n1.event "Event Name",
2> n1.event_count "Count",
3> n1.time_waited "Total Time",
4> round(n1.time_waited/n1.event_count, 2) "Avg Time"
5> from stats$event n1
6> where n1.event_count > 0
7> order by n1.time_waited desc;
Event Name Count Total Time Avg Time
-------------------------------- ------------- ------------- -------------
SQL*Net message from client 34369851 161024416 4.69
db file sequential read 18474734 11209083 .61
latch free 1673637 1478560 .88
buffer busy waits 2310599 1318970 .57
log file sync 150741 179103 1.19
db file parallel read 10358 23297 2.25
Saad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mouloudi, Saad
INET: Saad.Mouloudi_at_compaq.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 29 2001 - 09:31:32 CDT
 |
 |