Oracle-L: ORA-1115

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 02 Oct 2002 14:38:23 -0800
Message-ID: <F001.004DEAF9.20021002143823@fatcity.com>

I'm getting ORA-1115 errors that do not appear in the alert log nor do they specify the file name nor the block id, when performing certain operations against large, 100 million row plus tables. This is a 9.0.1.3 database.

I have seen some responses on other OS's which recommend turning off aysnchronous IO. As the file systems are cooked, which means Solaris will first try kernel AIO whch will fail, afterwhich the IO will be completed by a user thread. I have felt that when the Oracle documentaion refers to poor implementation of AIO, they are speaking of Solaris, but I haven't had a system sensitive to it before.

Inceasing the number of file descriptors is also mentioned. I may do this based on the future needs of the database, but the busiest process iscurrently only holding open files which number about 40% of the soft limit for that parameter.

The system adminsitrators report no problems with the T3's which hold the file system. I am able to export the database without incident, and also validate the indexes via analyze command. What fails are such things as create index, dbms_stats.analyze_schema.

Ian A MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Oct 02 2002 - 17:38:23 CDT