Utk PL/SQL gunakan package berikut ini: DBMS_PROFILER, DBMS_TRACE & DBMS_HPROF
bw --- In [email protected], Ratno Putro Sulistiyono <ra...@...> wrote: > > cobain pake explan: > EXPLAIN PLAN set statement_id='query_satu' FOR > select * from something; > > lalu buat ngecek informasi explainednya lakukan query > SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','query_satu','ALL')); > > 2010/6/14 dedi humaedi <rhamdeen...@...> > > > > > > > thx alot mas alwin..t. Hayo hayo penghuni milis yang lain..soalnya > > tugas kuliah ini nilainya tidak sempurna jika pengukuran berdasarkan > > elapsed time saja (response time) > > > > > > On 6/13/10, Alwin Sanjaya <alwinsanj...@...<alwinsanjaya%40gmail.com>> > > wrote: > > > 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 <rhamdeen...@... <rhamdeeneev%40gmail.com>> > > > > > >> > > >> > > >> 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]<indo-oracle-unsubscribe%40yahoogroups.com> > > > 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 > > > > > > > > > > > > > > > > -- > > Regards > > Dedi Caesar Humaedi > > > > > > > [Non-text portions of this message have been removed] >
