Dh, Berikut beberapa nilai parameter-nya:
db_block_buffers = 56579 shared_pool_size = 125829120 shared_pool_reserved_size = 6291456 large_pool_size = 5242880 java_pool_size = 5242880 log_buffer = 524288 db_block_size = 8192 sort_area_size = 6291456 sort_area_retained_size = 6291456 open_links = 4 db_files = 100 db_file_multiblock_read_count = 128 processes = 900 sessions = 995 open_cursors = 1500 max_dump_file_size = 10240 mts_servers = 0 compatible = 8.1.0 cpu_count = 2 Terima kasih. > From: Yulius Wibowo > > > Kalau error yg muncul juga ORA-04030, sepertinya masalah di PGA ? > Boleh tahu pembagian memory yg anda lakukan ? > > Dari memory RAM 2GB yg ada, > berapa utk SGA (shared_pool_size, large_pool_size ...) ? > > RAM = OS memory + PGA + SGA > > Bowo > > > > Dh, > > > > > > > > Mohon masukannya untuk penanganan error berikut saat session > > > mencapai 80-200 > > > > (jika session belum banyak, error tersebut tidak muncul, > contoh: > > > saat > > > > session baru mencapai 20, user A bisa connect, kemudian setelah > > > session > > > > mencapai 100, saat user A connect ulang, muncul error TNS- > 12500, > > > atau jika > > > > running proses yang cukup besar, muncul error ORA-04030) -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- 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/
