Kalau sql lengkapnya seperti ini Pak SELECT SUBSTR(MHS_NIM,1,2) ANG_BLANK FROM HIS_MF WHERE SEMESTER=:P_SMT GROUP BY SUBSTR(MHS_NIM,1,2) ------ :P_SMT = '051' ------ * Apakah ada memakai dynamic sql? - Tidak pakai dynamic sql pak, statement sqlnya static itu kasusnya waktu saya execute Report 6i untuk total record di table HIS_MF ada sekitar 200rb data
Tolong Bantuannya Pak Tomi, atau rekan2 yg lain pernah punya error seperti itu Terimakasih Ditya ----- Original Message ----- From: "Tomi Wijanto" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, April 06, 2006 3:56 PM Subject: Re: [indo-oracle] Error Signaled in Parallel query server P003 Urgent ?? > 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 > > > > > > -- -----------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/
