08 April 2011

ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")

Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_j000_19837.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:10 2011
Process J000 died, see its trace file
kkjcre1p: unable to spawn jobq slave process
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_cjq0_9471.trc:

Fri Apr 08 10:21:16 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q002_19865.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:16 2011
Process q002 died, see its trace file
Fri Apr 08 10:21:21 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_m000_19928.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:21 2011
Process m000 died, see its trace file
Fri Apr 08 10:21:32 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q000_20027.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:21:32 2011
Process q000 died, see its trace file
Fri Apr 08 10:21:49 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q002_20140.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kgsp-heap","kglss")
Fri Apr 08 10:21:49 2011
Process q002 died, see its trace file
Fri Apr 08 10:22:05 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_q000_20356.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:22:05 2011
Process q000 died, see its trace file
Fri Apr 08 10:22:22 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_m000_20453.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:22:22 2011
Process m000 died, see its trace file
Fri Apr 08 10:23:34 2011
Errors in file /oracle/db/tech_st/11.1.0/admin/OURPROD_our12db/diag/rdbms/ourprod/OURPROD/trace/OURPROD_m000_21062.trc:
ORA-04031: unable to allocate 800 bytes of shared memory ("shared pool","unknown object","kglss","kgllc")
Fri Apr 08 10:23:34 2011

More shared memory is needed than was allocated in the shared pool



Solution :-
I have increased the SQA_TARGET,pga_aggregate_target and sga_max_size on init$ORACLE_SID.ora file .

Example: -
Old SGA and PGA Size
sga_max_size    6    1094967296
sga_target    6    1094967296
pga_aggregate_target    1094967296

New SGA and PGA Size :-
pga_aggregate_target      2147483648    2G
sga_max_size        4294967296
sga_target        4294967296

No comments: