coba aja ini, kalau bisa nerjemahin outputnya sendiri....saya acungkan jempol 12 :-)
create table t ( x int ); insert into t values(1); select sid, type, id1, id2 ,lmode,request from v$lock where sid = (select sid from v$mystat where rownum = 1); set serveroutput on exec dbms_output.put_line( dbms_transaction.local_transaction_id(true)); select sid, type, id1, id2,lmode,request from v$lock where sid = (select sid from v$mystat where rownum = 1); update t set x = 0 where x=1; select sid, type, id1, id2,lmode,request from v$lock where sid = (select sid from v$mystat where rownum = 1); rollback; select x from t where x=1 for update; select sid, type, id1, id2,lmode,request from v$lock where sid = (select sid from v$mystat where rownum = 1); 2009/4/13 Freddie Tanuwijaya <[email protected]>: > > saya blom cek ke v$lock tapi yg pasti query pl/sqlnya tidak ada select for > update yg ada update dmna where nya menggunakan subquery. > Mohon bantuannya menerangkan kedua macam lock ini, saya masi awam di admin. > Thx > --- On Mon, 4/13/09, Ujang Jaenudin <[email protected]> wrote: > From: Ujang Jaenudin <[email protected]> > Subject: Re: [indo-oracle] Cara ngatasin Locking > To: [email protected] > Date: Monday, April 13, 2009, 9:17 AM > > > > > > > > > > > > > > > > > > dari v$lock typenya apa kah? > > TM or TX? > > kalau TM....apakah ada select for update? > > kalau TX apakah menggunakan connection pooling? > > > > On Sun, Apr 12, 2009 at 8:41 PM, Freddie Tanuwijaya > > <synar_0...@yahoo. com> wrote: > >> Saudara-saudara saya mempunyai masalah, saya mempunya 1 transaksi n biasanya >> itu membutuhkan waktu 1 menit untuk proses sehingga terjadi locking ketika >> ada transaksi yg lain, saya sudah bersusaha untuk mengurangi waktu prosesnya >> tapi hasilnya 1 menit sudah maksimal, apa ada cara lain untuk mengatasi >> kasus locking ini?? Thx > >> > >> > >> > >> > >> > >> [Non-text portions of this message have been removed] > >> > >> > >> > >> ------------ --------- --------- ------ > >> > >> -- > >> -----------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 > > http://ora62. wordpress. com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [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 > > > > -- thanks and regards ujang | oracle dba | mysql dba http://ora62.wordpress.com
