Dicoba dulu aja saran dari error message tsb. Naikkan saja nilai shared_pool_reserved_size. Kalau dibaca asktom, ini disebabkan aplikasi tidak menggunakan bind variables
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:528893984337 On Mon, Feb 9, 2009 at 12:45 PM, Subekti Pranoto <[email protected]> wrote: > 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". >
