Sedikit menambahkan..... :)
1) Asumsi: Dynamic Query
==> knp gak di debug aja PLSQL-nya ????
2) Asumsi : Static Query
==> Liat aja langsung di PLSQL.. :D
Notes:
iBatis adalah ORM, jadi gak ada hubunganya dengan stored procedure,
kecuali klw bikin query pakai iBatis, karna IBatis sendiri punya sintak
tersendiri di dalam nge-define suatu query...
tujuannya untuk mempermudah developer.....
Thanks and best regards
Piping
On Thu, Jul 16, 2009 at 11:05 PM, Taufiq Hidayat
<[email protected]>wrote:
>
>
> Dear pak hendra chen,
> Mungkin ini bisa membantu :)
>
> ORADEBUG SETORAPID <pid>;-- Debug session with the specified Oracle process
> ID.
>
> ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12;
> ORADEBUG TRACEFILE_NAME; -- Display the current trace file path
> ORADEBUG EVENT 10046 TRACE NAME CONTEXT OFF;
>
> tkprof <TRACEFILE_NAME> translated.txt sys=no waits=yes
> sort=prsela,exeela,fchela
>
> Best Regards,
>
> Taufiq
>
> ________________________________
> From: hendra chen <[email protected] <h3ndr4ch3n%40yahoo.com.sg>>
>
> To: [email protected] <indo-oracle%40yahoogroups.com>
> Sent: Thursday, July 16, 2009 1:17:50 PM
>
> Subject: Re: [indo-oracle] [Ask]Memonitor query yang sedang dieksekusi
>
> Dear pak ujang,
>
> maksud nya kita tambahkan di event parameter nya event 10046 ?
> trus restat database dan kita nanti bisa melihat semua query yang terjadi
> di database itu ?
> atau ada cara lain untuk melihat nya ?
>
> apa beda nya jika kita melihat dari table v$sql ?
>
> Thanks atas penjelasan nya
>
> Best Regards,
>
> Hendra
>
> --- On Thu, 16/7/09, Ujang Jaenudin <ujang.jaenudin@ gmail.com> wrote:
>
> From: Ujang Jaenudin <ujang.jaenudin@ gmail.com>
> Subject: Re: [indo-oracle] [Ask]Memonitor query yang sedang dieksekusi
> To: indo-oracle@ yahoogroups. com
> Date: Thursday, 16 July, 2009, 7:18 AM
>
> trace sql dgn event 10046 will do the best :D
> karena semua query di catet di tracefile
> dan dari pembacaan raw format tracefile tsb, akan sedikit mengetahui logic
> applikasi (from database point of view).
>
> On Wed, Jul 15, 2009 at 4:46 PM, Ifnu bima <ifnub...@gmail. com> wrote:
>
> > Hi all,
> >
> > Saya perlu memonitor query yang sedang dieksekusi dari aplikasi yang
> > berjalan. Tujuanya untuk debugging apakah query yang dibentuk dari
> > stored procedure sudah benar atau belum. Stored procedure dieksekusi
> > oleh aplikasi yang menggunakan ibatis.
> >
> > thanks for any help
> >
> > --
> > Senior Engineer @ ArtiVisi Intermedia
> > Java Training Center
> > See our course @ artivisi.com
> >
> > http://ifnu. artivisi. com
> > +62 856 9211 8687
> > regards
> >
> >
> > ------------ --------- --------- ------
> >
> > --
> > -----------I. N.D.O - O.R.A.C.L.E- --------- -----
> > Keluar: indo-oracle- unsubscribe@ yahoogroups. com
> > Website: http://indooracle. wordpress. com
> > http://www.facebook .com/group. php?gid=51973053 515
> > ------------ --------- --------- --------- --------
> >
> > Bergabung dengan Indonesia Thin Client User Groups,
> > Terminal Server, Citrix, New Moon Caneveral, di:
> > http://indo- thin.blogspot. comYahoo! Groups Links
> >
> >
> >
> >
>
> --
> thanks and regards
> ujang | oracle dba | mysql dba
> jakarta - indonesia
>
> [Non-text portions of this message have been removed]
>
> New Email names for you!
> Get the Email name you've always wanted on the new @ymail and
> @rocketmail.
> Hurry before someone else does!
> http://mail. promotions. yahoo.com/ newdomains/ sg/
>
> [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]
