Received: (qmail 15037 invoked from network); 3 Mar 2009 20:15:20 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 3 Mar 2009 20:15:18 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 29375BF2670; Tue, 3 Mar 2009 21:15:17 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id OgSw064ZCnOm; Tue, 3 Mar 2009 21:15:17 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9CCEDBF2672; Tue, 3 Mar 2009 21:15:16 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 03 Mar 2009 21:13:06 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 14334BF2C82 for ; Tue, 3 Mar 2009 21:13:06 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id t5VN+cX-kzI4 for ; Tue, 3 Mar 2009 21:13:05 -0500 (EST) Received: from us194mx04.tycoelectronics.net (us194mx04.tycoelectronics.net [198.175.154.225]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B100FBF2656 for ; Tue, 3 Mar 2009 21:13:05 -0500 (EST) Received: from us194mx11.tycoelectronics.net ([163.241.185.106]) by us194mx04.tycoelectronics.net with Microsoft SMTPSVC(6.0.3790.3959); Tue, 3 Mar 2009 21:13:04 -0500 Received: from us194mx07.tycoelectronics.net ([163.241.185.38]) by us194mx11.tycoelectronics.net with Microsoft SMTPSVC(6.0.3790.3959); Tue, 3 Mar 2009 21:13:04 -0500 Received: from us194mx002.tycoelectronics.net (163.241.202.108) by us194mx07.tycoelectronics.net (163.241.185.38) with Microsoft SMTP Server (TLS) id 8.1.340.0; Tue, 3 Mar 2009 21:13:03 -0500 Received: from us194mx002.tycoelectronics.net ([163.241.202.108]) by us194mx002.tycoelectronics.net ([163.241.202.108]) with mapi; Tue, 3 Mar 2009 21:13:03 -0500 From: "Johnson, William L (TEIS)" To: "Oracle-L@freelists.org" Date: Tue, 3 Mar 2009 21:13:02 -0500 Subject: Can anyone point me to some documentation - Oracle EE 9.2.0.8 running on Solaris 10 with ZFS. Thread-Topic: Can anyone point me to some documentation - Oracle EE 9.2.0.8 running on Solaris 10 with ZFS. Message-ID: <2F161F8A09B99B4ABF8AE832D546E78903B2CD85C8@us194mx002.tycoelectronics.net> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: multipart/alternative; boundary="_000_2F161F8A09B99B4ABF8AE832D546E78903B2CD85C8us194mx002tyc_" MIME-Version: 1.0 X-OriginalArrivalTime: 04 Mar 2009 02:13:04.0039 (UTC) FILETIME=[C01F6B70:01C99C6E] X-archive-position: 15446 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: WLJohnson@tycoelectronics.com Precedence: normal Reply-to: WLJohnson@tycoelectronics.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --_000_2F161F8A09B99B4ABF8AE832D546E78903B2CD85C8us194mx002tyc_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I am trying to run 64 bit Enterprise Edition Oracle 9.2.0.8 (yeah I know, u= pgrade, but it is a vendor application and I can not...) on Solaris 10 10/0= 8 s10s_u6wos_07b SPARC. We are utilizing ZFS and appear to be just getting killed with io issues. = I just can't find any articles that will let me do anything to alter mount = point options like I can do on HP-UX. We have the block size of the ZFS fi= le system matching the Oracle database (which is 8k) and we have the archiv= e log files @ 128k block size... I know there is a lot of data in a statspack report. Here is the summary. = This is a 23 minute period from this evening. Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % To= tal Event Waits Time (s) Ela T= ime -------------------------------------------- ------------ ----------- -----= --- async disk IO 105,340 1,045 45= .77 log file sync 2,952 419 18= .35 log file parallel write 5,456 269 11= .79 sbtwrite2 4,774 255 11= .16 control file parallel write 516 79 3= .44 This is just brutal. Does any suggestions for documentation that I can rea= d for help? Metalink just does not seem to have anything useful that I can= find. Thanks in advance for suggestions. Bill --_000_2F161F8A09B99B4ABF8AE832D546E78903B2CD85C8us194mx002tyc_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I am trying to run 64 bit Enterprise Edition Oracle 9.2.0.8 (yeah= I know, upgrade, but it is a vendor application and I can not…) on Solaris 10 10/08 s10s_u6wos_07b SPARC.

 

We are utilizing ZFS and appear to be just getting kille= d with io issues.  I just can’t find any articles that will let me= do anything to alter mount point options like I can do on HP-UX.  We have= the block size of the ZFS file system matching the Oracle database (which is 8k= ) and we have the archive log files @ 128k block size…

 

 

I know there is a lot of data in a statspack report. &nb= sp;Here is the summary.    This is a 23 minute period from this even= ing.

 

Top 5 Timed Events

~~~~~~~~~~~~~~~~~~     =             &nb= sp;            =             &nb= sp;          % Total

Event       &= nbsp;           &nbs= p;            &= nbsp;           &nbs= p;  Waits    Time (s) Ela Time

-------------------------------------------- ------------ ----------- --------

async disk IO            &= nbsp;           &nbs= p;            105,340       1,045    45.77

log file sync            = ;            &n= bsp;            = ;  2,952         419    18.35

log file parallel write    &= nbsp;           &nbs= p;            5,456         269    11.79

sbtwrite2      &nb= sp;            =             &nb= sp;           4,774         255    11.16

control file parallel write           &nbs= p;            &= nbsp;  516          79  &nb= sp;  3.44

 

This is just brutal.  Does any suggestions for docu= mentation that I can read for help?  Metalink just does not seem to have anythin= g useful that I can find.

 

Thanks in advance for suggestions.

Bill

--_000_2F161F8A09B99B4ABF8AE832D546E78903B2CD85C8us194mx002tyc_-- -- http://www.freelists.org/webpage/oracle-l