Re: Anyone running JFS2 Concurrent I/O with 9i on AIX 5.2?
- From: Kresimir Fabijanic <kfabijanic@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 28 Apr 2004 21:33:43 +1000
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
