Home > Oracle, Performance > TEMP file corruption

TEMP file corruption


Had an interesting file corruption problem today. Oracle 9i database in Solaris OS. Processes started failing with TEMP file corruption.

 ksedmp: internal or fatal error
 ORA-01114: IO error writing block to file 201 (block # 1329161)
 ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
 Additional information: 1329161
 Additional information: 31
 Additional information: 1327105
 ORA-01114: IO error writing block to file 201 (block # 1329161)
 ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
 Additional information: 1329161
 Additional information: 31
 Additional information: 1327105
 ORA-01114: IO error writing block to file 201 (block # 1329161)
 ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
 Additional information: 1329161
 Additional information: 31
 Additional information: 1327105
 ORA-01114: IO error writing block to file 201 (block # 1329161)
 ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
 Additional information: 1329161
 Additional information: 31
 Additional information: 1327105

The only change gone to the database was – change in pga_aggregate_target and workarea_size_policy – changed to AUTOMATIC. We have suspected, hitting a bug – MOS ID 8684595.8, Bug: 8684595 – TEMP file corruption after autoextension of a file. Disabled the auto extension and re-sized the file to a higher size. Problem just vanished!

About these ads
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: