ORA-1115

2002-10-02 Thread MacGregor, Ian A. 

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
[EMAIL PROTECTED] 

   
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re: ORA-1115

2002-10-02 Thread Jared . Still 

Ian,

I had a similar experience with Solaris, Oracle and Async Io aboiut 3 
years ago.

We were testing a Hitachi storage system, and making and some 
incompatibility
with the Hitachi drives and Solaris was causing the async timeout to take 
an extremely
long time.

Though I didn't get errors, writing to disk was painfully slow.  Turning 
off async in
init.ora did the trick.

Jared





MacGregor, Ian A. [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 10/02/2002 03:38 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:ORA-1115


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
[EMAIL PROTECTED] 

 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

ora 1115

2001-07-19 Thread Djaroud Salim 

hi,
i have an ora-7372 message when i do a simple select on a table.
what can i do for resolve that.
i'm on hpunix oracle 7.3.4

thanks in advance

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Djaroud Salim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).