Re: Anyone running JFS2 Concurrent I/O with 9i on AIX 5.2?

From: Kresimir Fabijanic <kfabijanic_at_optusnet.com.au>
Date: Wed, 28 Apr 2004 21:33:43 +1000
Message-ID: <408F9697.1000001@optusnet.com.au>

Mladen

JFS2 is IBM AIX Journalized File System (version 2, I guess), Concurrent I/O is a I/O feature of IBM's AIX explained in one of the white papers on IBM's site - they have tested Oracle database and compared results for I/O performance with raw, "cooked" and cio enabled file systems. It appears that cio gets performance few percent slower than raw file systems. We are using it on our sites and as we have build the new system (AIX5L 64-bit on p650, Oracle 9.2.0.4) from scratch and migrated from an aged 4.3 AIX 32-bit Oracle 8.1.7.0 parallel server, I can not compare the speed. In comparison to old system. new system flies - but the whole computer is far more powerful that the old one, so it would be comparing apples and oranges.

Word of warning - Oracle 9i - temp tablespace can not be on cio enabled file system - it causes ORA-600 for every query that needs sorting:

In SQL*Plus:
SQL> SELECT
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P002 ORA-00600: internal error code, arguments: [srsnext_1], [0], [], [], [], [],
[], []
In Alert log:
Errors in file /home/app/oracle/admin/pd01/bdump/pd01_p002_782462.trc: ORA-00600: internal error code, arguments: [srsnext_1], [0], [], [], [], [],
[], []

We had a TAR opened, but I am sure that there were few articles on metalink.

Hope this helps

Kind regards

Kresimir Fabijanic

Mladen Gogala wrote:

>What is JFS2? What is Concurrent I/O? Do you have a URL? I'm using JFS on Linux
>and I'm a fan, but I've never heard of JFS2 and concurrent I/O? What is the difference
>between JFS and JFS2, besides additional number at the end of the name?
>
>
>On 04/27/2004 11:37:44 AM, Thomas Jeff wrote:
>
>
>>Supposedly, the performance is much better due to alleviating the
>>inode write serialization issue.
>>Does Oracle enforce serialization if Concurrent I/O is turned on?
>>
>>
>>
>>

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 Wed Apr 28 2004 - 06:29:11 CDT