My disks are IDE but on other server
i have IDE too but no waiting or crash problem ...
I'm starting to suspect my raid controller
"Promise FastTrack" because if a add a 100 mb datafile
i have no problems ...
It seem that problem may affect all active session
and crash them ....
Here's my alert log when crashing
Thu Dec 04 10:05:06 2003
ALTER TABLESPACE IMAGE_DATA ADD
DATAFILE 'C:\ORACLE\ORADATA\JLRDB9\IMGDAT33.DBF'
SIZE 2000M AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
Thu Dec 04 10:08:11 2003
Errors in file c:\oracle\admin\jlrdb9\udump\jlrdb9_ora_1588.trc:
Thu Dec 04 10:08:11 2003
Errors in file c:\oracle\admin\jlrdb9\udump\jlrdb9_ora_2012.trc:
Thu Dec 04 10:08:15 2003
Completed: ALTER TABLESPACE IMAGE_DATA ADD
DATAFILE 'C:\ORAC
and here's the sql statement in the trace file :
- 2003-12-04 10:08:11.000
- SESSION ID:(28.16109) 2003-12-04 10:08:11.000
FATAL ERROR IN TWO-TASK SERVER: error = 12571
- 2003-12-04 10:08:11.000
ksedmp: internal or fatal error
Current SQL statement for this session:
SELECT /*+ CHOOSE */
S.STATUS "Status",
S.SERIAL# "Serial#",
S.TYPE "Type",
S.USERNAME "DB User",
S.OSUSER "Client User",
S.SERVER "Server",
S.MACHINE "Machine",
S.MODULE "Module",
S.CLIENT_INFO "Client Info",
S.TERMINAL "Terminal",
S.PROGRAM "Program",
P.PROGRAM "O.S. Program",
s.logon_time "Connect Time",
lockwait "Lock Wait",
si.physical_reads "Physical Reads",
si.block_gets "Block Gets",
si.consistent_gets "Consistent Gets",
si.block_changes "Block Changes",
si.consistent_changes "Consistent Changes",
s.process "Process",
p.spid, p.pid, si.sid, s.audsid,
s.sql_address "Address", s.sql_hash_value "Sql Hash", s.Action,
sysdate - (s.LAST_CALL_ET / 86400) "Last Call"
FROM
V$SESSION S,
V$PROCESS P,
sys.V_$SESS_IO si
WHERE
S.paddr = P.addr(+)
and si.sid(+)=s.sid
and (s.USERNAME is not null) and (NVL(s.osuser,'x')<>'SYSTEM') and
(s.type<>'BACKGROUND')
ORDER BY 11
DESC
Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3FCF4278.408044F2_at_remove_spam.peasland.com>...
> Are these disks SCSI or IDE? IIRC, IDE disks were never built to handle
> simultaneous requests. So your I/O request to allocate a datafile stops
> other I/O requests from occurring. If the database needs an I/O request,
> it must wait for the first one to complete.
>
> Cheers,
> Brian
>
>
>
> Chris wrote:
> >
> > Hi,
> >
> > When i'm adding datafiles, my server hang
> > all the connections are stopped or freeze ...
> > but my cpu is only running at 4 %
> >
> > I'm running Oracle 9.2.0.1.0 on a win2K box
> >
> > Any helps will be appreciated
> >
> > Thanks
> > Chris
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Thu Dec 04 2003 - 15:25:53 CST