Yg lama tuh process DELETE-nya khan? Penyebabnya "lamanya proses" ada beberapa kemungkinan: 1. Data yg sedang/akan di DELETE sedang di-lock oleh session lain. Penyebab lock bisa karena perintah UPDATE atau DELETE atau juga SELECT (SELECT menggunakan FOR UPDATE) atau LOCK TABLE atau DDL (ALTER TABLE ...).
Coba dicheck lewat: V$LOCKED_OBJECT join dgn DBA_OBJECTS 2. Index dari table tsb besar atau ada kemungkinan juga karena corrupt (kalau corrupt: sudah lama nunggunya hasilnya error pula!!). 3. I/O dan CPU server lagi tinggi - Coba check pakai performance tools (top, topas, ...) 4. ... --- In [email protected], bima boediman <bimaboedim...@...> wrote: > > iya mas, maksud saya, data tersebut tidak di lock oleh session lain, karena > itu data lama tetapi jika Statement "select" itu mengunci data tersebut nah > itu baru mungkin. Tetepi Select ga ngelock data kan ya? BTW udah 2jam > sekarang :D > > > > > ________________________________ > From: yulius_wibowo <yulius_wib...@...> > To: [email protected] > Sent: Thu, June 10, 2010 8:25:26 AM > Subject: [indo-oracle] Re: Normal Query LAMA? > > > Lho,... SQL statement yg anda berikan khan DELETE ya thow ??? > > > > Terus ane jalanin SQL seperti ini : > > > > > > --Delete from TABLE_NAME > > > --Where FIELD <= To_date('2009','YYYY') > > > > > bw > > --- In [email protected], bima boediman <bimaboediman2@> wrote: > > > > Uhm Saya rasa sih tidak ya.... karena di lock jika ada process lain kan? > > jika Cuman "Select" tidak di lock kan ya Mas Yulius? > > > > > > > > > > ________________________________ > > From: yulius_wibowo <yulius_wibowo@> > > To: [email protected] > > Sent: Thu, June 10, 2010 8:06:41 AM > > Subject: [indo-oracle] Re: Normal Query LAMA? > > > > > > Mungkin juga karena ada record(s) yg sedang dilock oleh session lain ? > > > > bw > > > > --- In [email protected], Hardi Tandiono <h4rd1_tt@> wrote: > > > > > > untuk query delete akan makan waktu lebih lama. ada baiknya querynya di > > > pecah dan dicommit setelah selesai. > > > contoh > > > > > > --Delete from TABLE_NAME > > > --Where FIELD <= To_date('20090131','YYYYMMDD') and FIELD >= > > > To_date('20090131','YYYYMMDD'); > > > commit; > > > --Delete from TABLE_NAME > > > --Where FIELD <= To_date('20090201','YYYYMMDD') and FIELD >= > > > To_date('20090228','YYYYMMDD'); > > > commit; > > > > > > dan seterusnya. > > > > > > > > > > > > > > > > > > > > > ________________________________ > > > From: bima boediman <bimaboediman2@> > > > To: [email protected] > > > Sent: Thu, June 10, 2010 8:32:57 AM > > > Subject: [indo-oracle] Normal Query LAMA? > > > > > > > > > Para sesepuh.... > > > > > > Ane ada tabel isinya kurang lebih 700rb Records.... > > > > > > Terus ane jalanin SQL seperti ini : > > > > > > --Delete from TABLE_NAME > > > --Where FIELD <= To_date('2009','YYYY') > > > > > > tapi udah 1jam 15 menit kok belum kelar ya?? apakah Normal atau ada yang > > > ga beres? Mohon INPO please.... > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > [Non-text portions of this message have been removed] >
