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