Sepertinya error yg Anda dapat tidak berhubungan dengan parallel process.. Coba disable dulu atribut parallel di table: ALTER TABLE table_name NOPARALLEL;
Kemungkinan besar masih akan ada error ORA-01008: not all variables bound. Kira2 sql lengkapnya gimana? Apakah ada memakai dynamic sql? regards, tomi --- Ditya Oo <[EMAIL PROTECTED]> wrote: > Selamat Siang Rekan's Oracle, > saya mempunyai permasalahan di server Oracle 10g > dengan error > > " ORA-12801: error Signaled in Parallel query > server P003" > " ORA-01008: not all variables bound" > --> select id,kelas,nim,substr(nama1,37) from > mahasiswa > group by.... > > Apa harus melakukan settingan DOP (degree of > parallelismnya di table) > seperti langkah dibawah > SQL> SELECT table_name, degree FROM user_table; > SQL> ALTER TABLE table_name PARALLEL 4; > SQL> SELECT table_name, degree FROM user_table; > > atau ada kaitannya dengan parameter > - parameter_max_server > - parallel_threads_per_cpu > - sessions > - prosesses > jika ada parameter2 yg harus disetting/dirubah untuk > memecahkan solusi > diatas, mungkin dari rekan2 yg berpengalaman dengan > maintenance DB bisa > memberikan solusi ? > > -dimana server oracle kami jalan pada spec > IBM server > procesor Intel P III 3Gb (single Processors) > 2Gb RAM > DB Oracle 10g r2 > Connection = Shared Server > > kondisi INIT.ORA sekarang > -------------------------------- > parameter_max_server = 40 > sessions = 700 > shared_server_sessions = 770 > processes = 600 > parallel_min_server = 0 > parallel_threads_per_cpu = 2 > > Minta Tolong Bantuannya > Ditya > > > > -- > -----------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 > > > [EMAIL PROTECTED] > > > > > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------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/
