Re: Oracle on Win2k and async I/O

Kevin,
The filesystem is NTFS.

C: NTFS Alloc Unit Size is 512 bytes, Compaq Array Stripe size is 128k
D: NTFS Alloc Unit Size is 4096 bytes, Compaq Array Stripe size is 16k
E: NTFS Alloc Unit Size is 4096 bytes, Compaq Array Stripe size is 16k

Thanks for the response.

Q: I'm not sure RAW can be used with Oracle on Windows, can it? If so, I'm not sure how to set it up, any tips?

Q: It's about a 400 Gig database, and the logs we are importing are about 2 Gig uncompressed, so 4Gig files are problematic (according to my DBA).

Any help based on the above info?

"Kevin Gillins" <k.gillins_at_verizon.net> wrote in message news:<am8fa3$5fl$1_at_nntp-m01.news.aol.com>...
> Marty,
>
> A couple of things, maybe you already seen them too. Oracle has in previous
> releases experienced autoextend errors up to 4gig files sizes.
>
> Is your file system NTFS or FAT or RAW. Some limits changed depending.
>
> To be safe I would stop my filesize at 4gig. I like to keep them smaller
> for backups anyway.
>
> Kevin Gillins
>
> "Marty Egan" <martyegan_at_rocketmail.com> wrote in message
> news:74ca126c.0209170758.4e2db400_at_posting.google.com...
> > I'm experiencing Oracle crashes that appear to be a problem with the
> > Oracle async I/O interaction with the OS / array controller driver /
> > array controller hardware. It appears that when Oracle goes to
> > auto-extend (e.g. the temp tablespace) that it is then trying to write
> > to a block inside the extended disk space before it actually has been
> > created / extended.
> > ===========================================
> > === Here's the SQL and the log. ===
> > === ===
> > === (My system config is after the log ===
> > === ===
> > === init.ora is after the system config ===
> > ===========================================
> >
> >
> >
> >
> >
> > SQL> CREATE INDEX STATS_INX ON STATS_IN(TIMEB) TABLESPACE ST_X;
> >
> > Index created.
> >
> > SQL> CREATE INDEX STATS_READERSX ON STATS_READERS(TIMEB) TABLESPACE
> > ST_X;
> >
> > Index created.
> >
> > SQL> CREATE INDEX STATS_DETAILEDX ON STATS_DETAILED(TIMEB) TABLESPACE
> > ST_DETAILX
> > ;
> >
> > Index created.
> >
> > SQL> CREATE INDEX TWISTER_DEBUGX ON TWISTER_DEBUG(TIMET) TABLESPACE
> > TW_DEBUGX;
> > CREATE INDEX TWISTER_DEBUGX ON TWISTER_DEBUG(TIMET) TABLESPACE
> > TW_DEBUGX
> >
> > From alert*.log *
> > ERROR at line 1:
> > ORA-00603: ORACLE server session terminated by fatal error
> >
> > Mon Sep 16 23:26:34 2002
> > Errors in file C:\oracle\admin\NEWSDB01\udump\ORA02264.TRC:
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> >
> > Mon Sep 16 23:26:42 2002
> > Errors in file C:\oracle\admin\NEWSDB01\udump\ORA02264.TRC:
> > ORA-00603: ORACLE server session terminated by fatal error
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> > ORA-01114: IO error writing block to file 201 (block # 261557)
> > ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> > OSD-04026: Invalid parameter passed. (OS 261572)
> >
> >
> >
> > ===================
> > === Sys Config ===
> > ===================
> > Oracle 9x
> > Win2k SP2 plus "critical" hotfixes.
> > Compaq Proliant ML570
> > Dual P3 Xeon with 1M cache
> > Smart Array 5302 controller with 128M RAM
> > 12-72Gig disk drives
> > =6 drives on bus 1
> > =6 drives on bus 2
> > Array 1
> > 72Gig = RAID 1 across bus 1 / id 1 and bus 2 / id 1
> > OS, pagefile, temp space
> > Array 2
> > 271Gig = RAID 5 across bus 1 / id 2-6
> > tablespace, roughly 2/3 capacity of array is filled
> > Array 3
> > 271Gig = RAID 5 across bus 2 / id 2-6
> > tablespace, roughly 1/2 capacity of array is filled
> >
> >
> >
> > ===================
> > === init.ora ===
> > ===================
> >
> ############################################################################
> ##
> > # Copyright (c) 1991, 2001 by Oracle Corporation
> >
> ############################################################################
> ##
> >
> > ###########################################
> > # Cache and I/O
> > ###########################################
> > db_block_size=8192
> > db_cache_size=335544320
> >
> > ###########################################
> > # Cursors and Library Cache
> > ###########################################
> > open_cursors=300
> >
> > ###########################################
> > # Diagnostics and Statistics
> > ###########################################
> > background_dump_dest=C:\oracle\admin\NEWSDB02\bdump
> > core_dump_dest=C:\oracle\admin\NEWSDB02\cdump
> > timed_statistics=TRUE
> > user_dump_dest=C:\oracle\admin\NEWSDB02\udump
> >
> > ###########################################
> > # Distributed, Replication and Snapshot
> > ###########################################
> > db_domain=""
> > remote_login_passwordfile=EXCLUSIVE
> >
> > ###########################################
> > # File Configuration
> > ###########################################
> > control_files=("C:\oracle\oradata\NEWSDB02\CONTROL01.CTL",
> > "C:\oracle\oradata\NEWSDB02\CONTROL02.CTL",
> > "C:\oracle\oradata\NEWSDB02\CONTROL03.CTL")
> >
> > ###########################################
> > # MTS
> > ###########################################
> > dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
> > "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
> > "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
> >
> > ###########################################
> > # Miscellaneous
> > ###########################################
> > compatible=9.0.0
> > db_name=NEWSDB02
> >
> > ###########################################
> > # Network Registration
> > ###########################################
> > instance_name=NEWSDB02
> >
> > ###########################################
> > # Pools
> > ###########################################
> > java_pool_size=33554432
> > shared_pool_size=335544320
> >
> > ###########################################
> > # Processes and Sessions
> > ###########################################
> > processes=300
> >
> > ###########################################
> > # Redo Log and Recovery
> > ###########################################
> > fast_start_mttr_target=300
> >
> > ###########################################
> > # Sort, Hash Joins, Bitmap Indexes
> > ###########################################
> > hash_area_size=10485760
> > sort_area_size=10485760
> >
> > ###########################################
> > # System Managed Undo and Rollback Segments
> > ###########################################
> > undo_management=AUTO
> > undo_retention=10
> > undo_tablespace=UNDOTBS
Received on Wed Sep 18 2002 - 19:09:39 CEST