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:
Post a Comment