OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-01114 (10.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01114 [message #302265]

Mon, 25 February 2008 01:44

stevefox777
Messages: 26
Registered: September 2006

Junior Member

I am running Oracle Analyze with the command below against 20 tables which has about 30000000 to 45000000 rows for each table.

dbms_stats.gather_table_stats (ownname=>'USER_1',tabname=>'TABLE_1',CASCADE=>FALSE,estimate_percent=>100);

However, I am getting the error below for some tables (some are succeeding) even though there is enough disk space and low CPU/Memory usage :

ORA-01114: IO error writing block to file %s (block # %s)

Unable to dump event group - SGA not mapped

(Extract from trace file)

Could someone tell me how I can fix this problem?

I guess that the error is occurring due to the lack of free space in the SGA but is there a way to check the SGA usage dynamically?

The below is the system I am using :

Oracle 10.2.0.3.0
OS : HP-UX 11.11
CPU : 875MHz x 12
Memory : 24GB

Any help will be greatly appreciated.

Steve

Report message to a moderator

Re: ORA-01114 [message #302267 is a reply to message #302265]

Mon, 25 February 2008 01:50

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-01114: IO error writing block to file %s (block # %s)
 *Cause:  The device on which the file resides is probably offline. If the
          file is a temporary file, then it is also possible that the device
          has run out of space. This could happen because disk space of
          temporary files is not necessarily allocated at file creation time.
 *Action: Restore access to the device or remove unnecessary files to free
          up space.

"SGA not mapped" are internal errors, no relation with a classic lack of free memory, maybe a memory leak.
I think you have to call Oracle support.

Regards
Michel

Report message to a moderator

Re: ORA-01114 [message #302270 is a reply to message #302265]

Mon, 25 February 2008 02:02

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> IO error writing block to file %s (block # %s)
Could you also check which particular tablespace/datafile is in question here?
I have seen ORA-01114 could be misleading sometimes.
Could you enable a 10046, level 12 trace and try the same
statement again to see in which stage it exactly happened?

Report message to a moderator