Thanks Pak Andrew, Jadi kira-kira solusinya SGA-nya diturunin ya? Atau koneksinya diganti dari dedicated ke shared?
Thanks again, --- In [email protected], "Andrew E.K." <[EMAIL PROTECTED]> wrote: > > Ini Kebetulan saya ada info dr Metalink : > > Problem Description > ------------------- > > You are receiving an ora TNS-12540 error intermitently > when trying to make connections to the database. OPS > and MTS are not being used in this configuration. > > The error might be: > > TNS-12540: TNS:internal limit restriction exceeded > > The alert log has an entry that looks like: > > skgpspawn failed category 27143 > > The skgpspawn failed message refers to a failure to spawn > a new session. > > > Solution Description > -------------------- > > Performance monitor shows that the instance that that has > the TNS-12540 error occurring is using right around 2gb of > memory. The SGA for the instance is about 1.8gb of memory. > Reconfiguring the SGA to take less memory allows for connections > to be made sucessfully. > > The most significant init.ora settings that are a candidate to > to reduce the size of the SGA are: > > db_block_buffers > shared_pool_size > java_pool_size > sort_area_size > sort_area_retained_size > > Explanation > ----------- > > Because non Enterprise Windows NT Server limits the amount of memory > used per process to 2gb, the process for the instance could not > allocate more memory for new connections. > > > References > ---------- > > A Microsoft document that explains what is termed 4GT RAM Tuning can > be found at: > > http://support.microsoft.com/support/kb/articles/Q171/7/93.ASP > > Ini Biasa nya karena memory Exhausted karena dedicated connectionnya. > Semoga Membantu :) > CMIIW > > Andrew E.K. > -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
