ORA-600 [srsnext_1] when running 9.2 on AIX 5.2
(Doc ID 262851.1)
Last updated on SEPTEMBER 18, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 13-May-2013***
JFS2 filesystem mounted with CIO option (introduced with AIX 5.2)
If tempfiles are located on a JFS2 filesystem mounted with the CIO (Concurrent I/O) option, introduced with AIX 5.2, then you might see ORA-600 [srsnext_1] being raised when extents are allocated in the tempfile, eg. when doing large sort operations.
Use the "mount" command to check for filesystems with CIO option:
$ /usr/sbin/mount | grep cio
Then check if any tempfiles are located on any of these filesystems:
SQL> select name from v$tempfile;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document