Pak Andrew, Server pake OS Windows 2000 Advance Server SP4, memory 8 GB. Yang terpakai untuk oracle baru sekitar 2 GB. Kalau dari penjelasan di metalink, seharusnya Win 2K Advance Server SP4 sudah bisa jalanin proses diatas 2 GB ya? Mungkin bisa kasih pencerahan, Pak?
NB: di boot.ini-nya sudah ditambahin : multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /PAE /3GB supaya bisa pake memory sampai 3 GB. Thanks, --- In [email protected], "Andrew E.K." <[EMAIL PROTECTED]> wrote: > > Iya mungkin bisa dicoba diturunkan value SGA nya,tetapi liat2 jg sih kalo memang usernya yg butuh untuk transaksi itu banyak ...mungkin bisa dipertimbangkan menambah kapasitas memmory nya pak. > Kalo diubah ke shared server mungkin bisa dibaca dulu di dokumentasi untuk detailnya sebagai pertimbangan karena mesti disesuaikan dengan kebutuhan dan karakteristik transaksi nya jg. > Semoga membantu > > Andrew > > lospubro <[EMAIL PROTECTED]> wrote: 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 > > > > SPONSORED LINKS > Membership database software Database mortgage software Pda database software Database management software Oracle database administration Oracle database management > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "indo-oracle" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > > > --------------------------------- > Yahoo! Photos > Got holiday prints? See all the ways to get quality prints in your hands ASAP. > > [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.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/
