1 Attachment(s)
Ora-04031 Unable To Allocate 316 Bytes Of Shared Memory
HELLO ORACLE GURU'S
I AM FACING A STRANGE PROBLEM I MY DATABASE I HAVE 2 VIEWS :
PENDING_ANX_IV_POST_VIEW & PENDING_ANX_V_POST_VIEW.
WHEN EVER I USE TO RUN THESE VIEWS THEY BOTH GIVE SAM ERROR :
ORA-04031: unable to allocate 316 bytes of shared memory
("large pool","unknown object","cursor work he","kdiixs1 : kdipc")
HOWEVER WHEN I VIEW SHARED POOL AND LARGE POOL THE STATISTICS IS :
SGA CACHE STATISTICS
********************
SQL Cache Hit rate = 99.73
Dict Cache Hit rate = 92.03
Buffer Cache Hit rate = 99.93
Redo Log space requests = 1
Total SGA = 292.69
INIT.ORA SETTING
****************
Shared Pool Size = 149380352 Bytes
DB Block Buffer = 47202 Blocks
Log Buffer = 32768 Bytes
Main SGA Areas NAME SUM(BYTES)
-------------------- -------------------- ----------------
DB Buffer Cache db_block_buffers 386,678,784
Shared Pool shared pool 158,447,628
Large Pool large pool 40,405,560
Redo Log Buffer log_buffer 65,536
Fixed SGA fixed_sga 65,484
----------------
585,662,992
Shared Pool Areas NAME SUM(BYTES)
-------------------- -------------------- ----------------
Shared Pool free memory 133,477,124
Shared Pool miscellaneous 14,100,744
Shared Pool sql area 5,939,240
Shared Pool library cache 4,290,964
Shared Pool dictionary cache 639,556
----------------
sum 158,447,628
I AM ATTACHING SOURCE CODE OF BOTH VIEWS. WHEN I USE TO RUN THESE VIEWS BY MAKING PART OF IT. THEY RUN SUCCESFULLY. I AM NOT GETTING WHAT IS THE PROBLEM.
PLEASE HELP WHAT IS THE REASON.
REGARDS
GURPREET SINGH SETHI
Re: Ora-04031 Unable To Allocate 316 Bytes Of Shared Memory
What do you mean by "RUN A VIEW"??