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 <[email protected]> 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 <bimaboedim...@...> 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_wib...@...> > 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]
