ORA-27072: skgfdisp: I/O error

From: Parvinder Singh <parora_at_questone.com>
Date: Tue, 18 Jan 2000 16:07:58 GMT
Message-ID: <38848F8E.7373B930@questone.com>

Hi all

 I have a table msr1_tab which contains 1 million recs after executing the
 following query it gave me the following error message after 1 hour ...how
 do i handle the error ??
 i have also created one more file and associated with the TEMP tablespace
 but still it gave the same error

  i also rebooted my machine and again executed the same query this time it gave me the same error with some other block number (337624) the size of /usr/oracle/oradata/Oradata/temp01.dbf is 691716096 bytes  the thing which i noticed is that my data is mounted on /usr partition and the available space on that partition is just around 6MB ..will that make a difference ?? i guess it should not because i have one more temp02.dbf file whose size is 400MB on the other partition which is associated with the TEMP tablespace so it can use that file for storing the temporary data while executing the query what do you say am i right ??

 any idea?
 Thanks & Regards
 ~Parvinder

also reply to parora_at_questone.com

 11:40:46 SQL > select msr1_tab.pg_id, msr1_tab.ls_id, msr1_tab.res_id, msr1_tab.mth_id, msr1_tab.qtyno

 11:40:47   2  from msr1_tab, program,
 11:40:47   3  logistic_system,res,month
 11:40:47   4  where msr1_tab.pg_id in(
 11:40:47   5  select pg_id from program where pg_hierarchy= 'STANDARD')

 11:40:47 6 and msr1_tab.ls_id in(
 11:40:47 7 select ls_id from logistic_system where ls_hierarchy =  'STANDARD')
 11:40:47 8 and msr1_tab.res_id in
 11:40:47 9 (select res_id from res where res_hierarchy = 'STANDARD')

 11:40:47  10  and msr1_tab.mth_id in
 11:40:47  11  (select mth_id from month)
 11:40:47  12  and program.pg_id = msr1_tab.pg_id
 11:40:47  13  and logistic_system.ls_id = msr1_tab.ls_id
 11:40:47  14  and res.res_id = msr1_tab.res_id
 11:40:47  15  and month.mth_id = msr1_tab.mth_id;
 from msr1_tab, program,
      *

 ERROR at line 2:
 ORA-19502: write error on file
"/usr/oracle/oradata/Oradata/temp01.dbf",  blockno 337616
 (blocksize=2048)
 ORA-27072: skgfdisp: I/O error
 SVR4 Error: 25: Inappropriate ioctl for device  Additional information: 337616

  real: 4096680
 12:49:05 SQL Received on Tue Jan 18 2000 - 10:07:58 CST