Oracle : 10g R2, 32 bit
Fisik Memory : 8 GB
OS : Kernel 2.6.18-92.el5PAE (RHEL/CentOS 5.2), 32 bit
Automatic Shared Memory Management Enabled
Total SGA Size (MB) : 2048
Dear all,
1. saya setup ASSM enabled, tp masih mendapatkan ora-04031. Mengapa hal ini
bisa terjadi??
2. Apakah besaran masing-masing komponen SGA (Shared Pool,Buffer Cache, Large
Pool, Java Pool, dan Other ) masih perlu disetting manual??
3. Berapa Nilai setting manual itu berdasarkan best practise Mode Koneksi
"Shared Server" ?
Note:
ORA-04031: unable to allocate string bytes of shared memory
("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the dbms_shared_pool
package to pin large packages, reduce your use of shared memory, or increase
the amount of available shared memory by increasing the value of the INIT.ORA
parameters "shared_pool_reserved_size" and "shared_pool_size". If the large
pool is out of memory, increase the INIT.ORA parameter "large_pool_size".
regard,
subekti
[Non-text portions of this message have been removed]
