Problems with "skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn"
- From: "Richard Saints" <saints.richard@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 17 May 2007 11:28:01 +0100
Hello to you all,
I'm experiencing some problems with an Oracle Database (10g release 1 - *
10.1.0.2*) on a Windows Server (2000 Advanced Server - SP4).
I'm repeatedly getting the following error on the alert.log file:
*skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc =
skgpspawn*
When this happens, the processes become slow and after a while the DB stops
to accept new connections. This last situation didn't loged any ORA error on
alert.log. From what I investigated so far, it seems to be a lack of
resources problem, probably memory. I don't have any other error associated
with this situation, like ORA-04030, for example. I'm a bit confused and I
would appreciate some help.
The server where I'm running the Oracle Database has the following
characteristics:
HP Proliant DL380
2 x Pentium Xeon 3,2 GHz
4 GB of RAM
HP Smart Array SCSI controller
2x36GB SCSI RAID 1 internal discs with 2 logical drives:
C drive for OS
D drive for Logs
4x146 GB SCSI RAID 5 internal discs with 1 logical drive:
F drive for data
Paging size on C drive (2048-4096)
Should I increase the paging size ?
I've the Total SGA size and the Maximum SGA size with the same value (1536
MB). The Automatic Shared Memory Management is Enabled.
The Aggregate PGA target is 331 MB
Here's a list of my Oracle initialization parameters:
compatible = 10.1.0.2.0
db_block_size = 8192
__db_cache_size = 1275068416
db_cache_size = 16777216
db_domain = ''
db_file_multiblock_read_count = 16
db_name = NESFA
db_recovery_file_dest = F:\oracle\product\10.1.0\flash_recovery_area
db_recovery_file_dest_size = 53687091200
dispatchers = '(PROTOCOL=TCP) (SERVICE=NESFAXDB)'
__java_pool_size = 8388608
java_pool_size = 8388608
job_queue_processes = 10
__large_pool_size = 8388608
large_pool_size = 8388608
open_cursors = 3000
pga_aggregate_target = 347078656
processes = 250
sessions = 280
sga_max_size = 1610612736
sga_target = 1610612736
__shared_pool_size = 310378496
shared_pool_size = 8388608
sort_area_size = 65536
undo_management = AUTO
undo_tablespace = UNDOTBS1
parallel_max_servers = 80
parallel_server = FALSE
parallel_server_instances = 1
parallel_threads_per_cpu = 2
max_dispatchers = NULL
max_shared_servers = NULL
shared_servers = 1
Thanks for all your attention.
Best regards,
Ricardo Bateiras.
Other related posts:
