Oracle Database Discussions

Hi All,

DB:oracle 9.2.0.4
OS:solaris

i am facing below error...while executing the 1 year archival job(manually).

ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","sga heap(1,0)","library cache")
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","select i.obj#,i.ts#,i.file#,...","sga heap(1,0)","library cache")


POOL NAME BYTES
fixed_sga 734530
buffer_cache 3690987520
log_buffer 1311744
shared pool enqueue 2886928
shared pool KGK heap 13400
shared pool KQR L PO 1087928
shared pool KQR L SO 71696
shared pool KQR M PO 923720
shared pool KQR M SO 297768
shared pool KQR S SO 13848
shared pool sessions 4177680
shared pool sql area 2614032
shared pool 1M buffer 2098176
shared pool KGLS heap 243384
shared pool PX subheap 139448
shared pool parameters 2128
shared pool free memory 42360200
shared pool transaction 2838752
shared pool PL/SQL DIANA 606104
shared pool FileOpenBlock 15767752
shared pool PL/SQL MPCODE 106776
shared pool library cache 144682208
shared pool miscellaneous 44373928
shared pool PLS non-lib 2088
shared pool joxs heap init 4240
shared pool trigger inform 280
shared pool Checkpoint queue 8202240
shared pool dictionary cache 4274432
shared pool db_block_hash_buckets 23411632
shared pool event statistics per sess 17563560
shared pool fixed allocation callback 2776
large pool PX msg pool 3538944
large pool free memory 13238272
java pool free memory 33554432

=====SGA=====
NAME VALUE
-------------------- ----------
Fixed Size 734530
Variable Size 369098750
Database Buffers 3690987520
Redo Buffers 1335290


can any one help to me ...

thanks.

Edited by: kk001 on Feb 7, 2012 8:58 PM