 Posted 1/1/2009 7:09:23 AM
|
|
|
|
You will see following ora error :
ORA-01114: IO error writing block to file 202 (block # 458633)
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 122880
or
ORA-01114: IO error writing block to file 202 (block # 458633)
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 122880
This means that a datafile cannot extend anymore because a disk (or mount point / raw device / or any storage device) is full.
Specifically, the high numbering of the file (in blue), refers to a temporary file.
If the number is in the range between 1 - DB_FILES, where DB_FILES is an initialization parameter whose value can be retrieved either with:
select * from v$parameter
where name = 'db_files';
or in SQL*Plus with
show parameter db_files
This means that we are talking of an ordinary datafile.
In this case DB_FILES was set to 200, which means that 202 refers to a temporary file and tempfiles are numbered starting from DB_FILES + 1.
If the temporary file is set to AUTOEXTEND ON, then the root cause of the problem can be a huge query on a view requiring a big sort operation or the insertion of lots of rows into a temporary table that made the temporary tablespace grow larger than usual until all the space on the device was used up.
One of things you want to do is check if temporary files are not sitting in the same filesystem as your datafiles. If you see this, then take the necessary steps to drop the tempfiles from the shared location and put them all in a single filesystem separate from the datafiles. Make sure that you have enough filesystem space on the new filesystem where the temp files will reside. Of course this is application dependant.
|
|
|
Posted 1/18/2009 2:03:48 PM
|
|
|
|
Reference :
ORA-01114 IO error writing block to file string (block # string)
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.
|
|
|
Posted 1/18/2009 2:04:48 PM
|
|
|
|
Reference:
ORA-27063 skgfospo: number of bytes read/written is incorrect
Cause: The number of bytes read/written as returned by AIOWAIT does not match the original number, additional information indicates both these numbers.
Action: Check errno.
|
|
|
|