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 <[email protected]>
>
>
> 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 <[email protected]<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 <[email protected] <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]
------------------------------------
--
-----------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/
