Dear mas Dedi, Kalau saya untuk mengukur elapsed time biasanya pakai cara "urdu", biasanya saya kasih perintah insert into table diawal dan akhir procedure yang mencatat mulainya program dijalankan hingga selesai program dijalankan. Bentuknya seperti ini :
Begin Insert Into Elapsed_Time_Table (time) Values (sysdate); Procedure_A(x, y); .... .... Insert Into Elapsed_Time_Table (time) Values (sysdate); Commit; End; Sehingga nanti ketahuan mulai menit keberapa hingga menit keberapa procedure dijalankan, untuk yang statistic dan explain plan saya belum tahu, mungkin teman2 bisa menambahkan. Regards, Alwin.S 2010/6/13 dedi humaedi <[email protected]> > > > Dear all saya mau tanya nih kalau mau mengukur elapsed time dan > statistic plus mengetahui explain dari pl/sql bagaimana caranya ya? > Trims > > -- > Regards > Dedi Caesar Humaedi > > [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/
