Pak gD Sudi,
Error tadi menunjukkan bahwa Oracle membutuhkan resource memory yg lebih
besar drpd yg telah dialokasikan.
Coba anda besarkan parameter untuk shared memory di Oracle..
Adapun yg mungkin bisa anda coba untuk ubah adalah parameter :
- shared_pool_reserved_size
- shared_pool_size
- large_pool_size
Di mana pada email anda (current value) terlihat besarnya shared pool =
80MB, Large Pool = 8MB
Happy trying :)
On 9/19/06, gede sudi <[EMAIL PROTECTED]> wrote:
>
> Teman-teman saya menemui error seperti ini :
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","select /*+ rule */ bucket, e...","Typecheck heap","kgghteInit")
>
> eror itu muncul waktu saya coba konek lewat Enterprise Manager atau sql
> plus
> dimana sebelumnya saya menjalani program dengan data yang banyak (program
> data mining) yang melibatkan query berulang-ulang
>
> Saya pake Oracle 10 g release 1 dengan memory 512 MB serta settingan sbb:
> share pool =80MB, Buffer cache=24MB, Large Pool=8 MB, Java Pool=48 MB, SGA
> Max Size=164 MB Agregate PGA Target=24 MB
>
> Mungkin teman-teman ada solusi.
> Dan sebelumnya diucapkan terima kasih atas solusinya
>
> D'Sudi
>
> [Non-text portions of this message have been removed]
>
>
>
--
«אּ♪ ΔŒ ♪אּ»
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indo-oracle/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
