From oracle-l-bounce@freelists.org Tue Jul 26 17:11:22 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6QMBMYM028288 for ; Tue, 26 Jul 2005 17:11:22 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6QMBKIP028278 for ; Tue, 26 Jul 2005 17:11:20 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CD9801D798E; Tue, 26 Jul 2005 17:11:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03637-04; Tue, 26 Jul 2005 17:11:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 453821D7957; Tue, 26 Jul 2005 17:11:16 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5922E.A45D94FD" Subject: low blocks/read on temp Date: Tue, 26 Jul 2005 17:09:06 -0500 Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E36B4EDA1@CWYMSX04.Corp.Acxiom.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: low blocks/read on temp Thread-Index: AcWSLqQGS61pfgEGQ1OMC0dVkRhwBw== From: "Herring Dave - dherri" To: "Oracle-L@Freelists. Org (E-mail)" X-OriginalArrivalTime: 26 Jul 2005 22:09:07.0486 (UTC) FILETIME=[A46FABE0:01C5922E] X-archive-position: 22928 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Dave.Herring@acxiom.com Precedence: normal Reply-To: Dave.Herring@acxiom.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.5 required=5.0 tests=AWL,BAYES_00,HTML_60_70, HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5922E.A45D94FD Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Has anyone run into situations where the avg blocks per read against their temporary tablespace seemed extremely low? We have a database block size of 32K, yet I'm seeing blocks per read on TEMP 5.2, on average. I would expect much, much higher, at least in the 20's. Is this a realistic expectation? =20 I'm running 9.2.0.4 on Tru64 5.1. =20 Thanks. =20 Dave ------------------------------------- Dave Herring, DBA Acxiom Corporation 3333 Finley Downers Grove, IL 60515 wk: 630.944.4762 > ------------------------------------- =20 ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination,=20 distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ------_=_NextPart_001_01C5922E.A45D94FD Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Has anyone run into situations where the avg blocks per = read against their temporary tablespace seemed extremely low?  We have a da= tabase block size of 32K, yet I'm seeing blocks per read on TEMP 5.2, on average.&= nbsp; I would expect much, much higher, at least in the 20's.  Is this a reali= stic expectation?

 

I'm running 9.2.0.4 on Tru64 5.1.

 

Thanks.

 

Dave

-------------------------------------<= /span>

Dave Herring, DBA

Acxiom Corporation<= /o:p>

3333 Finley

Downers Grove, IL 60515<= o:p>

wk: 630.944.4762

<<= span style=3D'font-family:Arial'>mailto:dherri@acxi= om.com>

-------------------------------------<= /span>

 



**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
 ------_=_NextPart_001_01C5922E.A45D94FD-- -- http://www.freelists.org/webpage/oracle-l