I received the following errors in my alert log:
ORA-27300: OS system dependent operation:spcdr:9261:4200 failed with status: 997
failure message: Overlapped I/O operation is in progress
ORA-27302: failure occurred at: skgpspawn
I am using Oracle 10g 10.2.0, on Windows 2003
Server, with sga size =1230 MB.
How do I deal with this problem?
To diagnose any error, you first start by using the
oerr utility to display the ORA-27300 error:
ORA-27300: OS system dependent operation: string failed with status:
OS system call error
Contact Oracle Support
Support advises that there is a bug: BUG 5607984 - ORACLE DOES NOT CLOSE
TCP CONNECTIONS. REMAINS IN CLOSE_WAIT STATE. on Windows 32-bit.
Patch number 5639232 that Oracle Support can provide is supposed to solve the problem for
10.2.0.2.0. This bug is also supposed to be solved in the 10.2.0.3.0 patchset
that is available on the Metalink site.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.