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:
- » Problems with "skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn"
- » Re: Problems with "skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn"
- » RE: Problems with "skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn"