Re: Can I tryst in "physical ... direct" figures?
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Sep 2004 21:55:32 -0700
It's not for me to tell you where you can tryst, or with whom.
But, getting back to direct read/writes... are you doing a lot of sorting?
Are you doing a lot of LOB access? Does your Statspack report show a lot of
direct path reads/writes?
--Terry
----- Original Message -----
9.2.0.5 EE on Lintel RH AS 2.1
OLTP ~200 connections.
Today a have observed figures below in statspack report
Statistic Total per Second per
Trans
--------------------------------- ------------------ --------------
------------
physical reads 19,327,036 429.5 205.8
physical reads direct 10,482,393 232.9 111.6
physical writes 16,465,203 365.9 175.3
physical writes direct 16,343,723 363.2 174.0
It seams very strange to me that almost all writes and more then 1/2 of
reads is direct.
What do you think, can I trust on those figures? Can it be truth that all
writes are direct "bypassing the buffer cache, as written in Docs?
PS Report interval 750.02 (mins)
PS I know - SP aggregates live. Don't tell me do not look on it.
Jurijs
+371 9268222 (+2 GMT)
============================================
Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
