saya naikkan job_queue_processes nya, mudah-mudahan berhasil (soalnya masih harus tunggu proses berikutnya besok pagi)
terima kasih. 2008/8/28 Yoel Susanto <[EMAIL PROTECTED]> > sekali lagi...di oracle10g di recommend gunakan DBMS_SCHEDULER maka > tidak > perlu job_queue_processes > > DBMS_JOB is for backward compatibility. > > 2008/8/28 eko suprijantono <[EMAIL PROTECTED]<ekosuprijantono%40yahoo.com> > > > > > > Bisa dinaikin jumlahnya dng perintah > > alter system set job_queue_processes=50 > > > > > > ----- Original Message ---- > > From: Yoel Susanto <[EMAIL PROTECTED] > > <yoel.susanto%40gmail.com><yoel.susanto% > 40gmail.com>> > > To: [email protected] <indo-oracle%40yahoogroups.com><indo-oracle% > 40yahoogroups.com> > > Sent: Thursday, August 28, 2008 5:26:59 AM > > Subject: Re: [indo-oracle] jumlah maksimum job di oracle 10g > > > > gunakan DBMS_SCHEDULER untuk lepas dari job_queue_processes > > > > 2008/8/28 bukhari yahya <bukhariyahya@ gmail.com> > > > > > coba cek parameter untuk > > > job_queue_processes = ... ? > > > > > > SQL> show parameter job_queue_processes > > > kalau masih bernilai 10 coba dinaikkan > > > 2008/8/28 indra syafruddin <[EMAIL PROTECTED] com <indra.e00%40gmail. > > com>> > > > > > > > > > > Dear all, > > > > > > > > Saya membuat job di oracle 10g. ada sekitar 14 job yang berjalan > > > bersamaan. > > > > Tetapi kenapa hanya 10 job yang bisa berjalan? yang lainnya baru > > berjalan > > > > setelah salah satu jobs berhenti (disabled). Bagaimana cara > > meningkatkan > > > > jumlah jobs di Oracle 10g ? > > > > > > > > Terima kasih. > > > > > > > > [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]
