Home » RDBMS Server » Server Administration » ORA-01114 (10.2.0.3.0)
ORA-01114 [message #302265] Mon, 25 February 2008 01:44 Go to next message
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
Re: ORA-01114 [message #302267 is a reply to message #302265] Mon, 25 February 2008 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-01114 [message #302270 is a reply to message #302265] Mon, 25 February 2008 02:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?
Re: ORA-01114 [message #302273 is a reply to message #302270] Mon, 25 February 2008 02:21 Go to previous messageGo to next message
stevefox777
Messages: 26
Registered: September 2006
Junior Member
Mahesh,
Thanks for your response.

Could you tell me how to enable 10046 and level 12 trace?

Thanks
Steve
Re: ORA-01114 [message #302276 is a reply to message #302273] Mon, 25 February 2008 02:47 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Pete Finnigan, How to set trace for others sessions, for your own session and at instance level

Regards
Michel
Previous Topic: Status Invalid for Synonym
Next Topic: starter database
Goto Forum:
  


Current Time: Sat Dec 10 03:16:56 CST 2016

Total time taken to generate the page: 0.08791 seconds