terima kasih semua.. atas jawaban nya ..! thx, Dody
--- On Fri, 7/11/08, Yoel Susanto <[EMAIL PROTECTED]> wrote: From: Yoel Susanto <[EMAIL PROTECTED]> Subject: Re: [indo-oracle] Re: Cek Max Connection Oracle To: [email protected] Date: Friday, July 11, 2008, 3:37 AM kalo liat tidak ada ORA - error, ini dari java nya s 2008/7/11 dody osmon <dodytanjung79@ yahoo.com>: > ini ada error: > No ManagedConnections available within configured blocking timeout ( 30000 > [ms] ); - nested throwable: (javax.resource. ResourceExceptio n: No > ManagedConnections available within configured blocking timeout > > kira2 error ini, berhubungan sama jumlah process ga ? sebelom nya jumlah > process sudah di naikin 500 , trus di naikin 1500 tetap saja masih ada error > ini , apa error ini timbul dari java / j-boss nya ? > > terima kasih atas respon dan jawabannya ? > > Thx, > Dody > > --- On Fri, 7/11/08, Yoel Susanto <yoel.susanto@ gmail.com<yoel.susanto% > 40gmail.com> > > wrote: > From: Yoel Susanto <yoel.susanto@ gmail.com <yoel.susanto% 40gmail.com> > > Subject: Re: [indo-oracle] Re: Cek Max Connection Oracle > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > Date: Friday, July 11, 2008, 3:24 AM > > select COUNT(1) aja dari v$session dan v$process > > 2008/7/11 dody osmon <dodytanjung79@ yahoo.com>: > > > untuk melihat process dan sessions yang ke pakai , bagaimana cara > > > perhitungannya ? > > > > > > thx, > > > Dody > > > > > > --- On Fri, 7/11/08, rohmadsan <[EMAIL PROTECTED] com<rohmadsan% 40yahoo. > com>> > > > wrote: > > > From: rohmadsan <[EMAIL PROTECTED] com <rohmadsan%40yahoo. com>> > > > Subject: [indo-oracle] Re: Cek Max Connection Oracle > > > To: indo-oracle@ yahoogroups. com <indo-oracle% 40yahoogroups. com> > > > > Date: Friday, July 11, 2008, 12:09 AM > > > > > > > > > Hallo... > > > > > > Untuk melihat max session, gunakan: > > > > > > SQL> show parameter sessions > > > > > > Contoh hasilnya: > > > > > > sessions integer 49 > > > > > > Untuk melihat max process, gunakan: > > > > > > SQL> show parameter processes > > > > > > Contoh hasilnya: > > > > > > processes integer 40 > > > > > > Untuk menaikkan jumlah session, kedua parameter di atas harus > > > > > > dinaikkan. Misalkan kita ingin menaikkan maximal session di instance > > > > > > kita sebesar 500. > > > > > > Best practice-nya, beri nilai berikut: > > > > > > processes=500 > > > > > > sessions=520 > > > > > > "sessions" harus lebih banyak, ini untuk mengakomodasi session yang > > > > > > di-create oleh background process-nya Oracle. > > > > > > Salam, > > > > > > Rohmad > > > > > > http://rohmad. net/2008/ 07/08/daftar- artikel-di- rohmadnet/ > > > > > > --- In indo-oracle@ yahoogroups. com, dody osmon <dodytanjung79@ ...> > > > wrote: > > > > > > > > > > > > > > Hai, > > > > > > > > > > > > > > Mau tanya nih untuk cek max connection oracle gimana ? biasa selama > > > > > > ini untuk menaikkan jumlah connection, dengan increase jumlah > > > > > > processes nya .. > > > > > > > > > > > > > > Thx, > > > > > > > Dody > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > -- > > Cheers, > > Yoel Susanto > > www.indo-oracletech .com > > [Non-text portions of this message have been removed] > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > -- Cheers, Yoel Susanto www.indo-oracletech .com [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
