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