Bagaimana kalau gini: select ss.sid, ss.serial#,ss.machine, substr(ss.username,1,12) user_name, sq.sql_text from v$session ss, v$sqlarea sq where ss.sql_address=sq.address and ss.machine like 'A' and sq.sql_text like '%namatable%;
salam, ~holly~ 2010/4/26 Henry <[email protected]> > > > Karena Sessionnya tidak locking suatu table. > Kalau hanya select, tidak lock, lock biasanya untuk DML. > Kalau pengen tahu querynya apa paling gampang ya pakai Enterprise Manager. > Itupun kadang tidak semua query kelihatan. terutama yang dibelakang > stored procedure. > > memangnya kebutuhannya gimana nich > > > On 4/25/2010 9:37 PM, Sandi Jatmika wrote: > > > > > > > > Kenapa hasilnya seperti ini ya? > > > > SQL> Select > > 2 c.owner, > > 3 c.object_name, > > 4 c.object_type, > > 5 b.sid, > > 6 b.serial#, > > 7 b.status, > > 8 b.osuser, > > 9 b.machine > > 10 from > > 11 v$locked_objec > > 12 v$session b, > > 13 dba_objects c > > 14 where > > 15 b.sid = a.sess > > 16 and > > 17 a.object_id = = c.object_id; > > > > no rows selected > > > > ________________________________ > > From: Henry <[email protected] <shgunawan%40vianet.ca> <mailto: > shgunawan%40vianet.ca <shgunawan%2540vianet.ca>>> > > To: [email protected] <indo-oracle%40yahoogroups.com> <mailto: > indo-oracle%40yahoogroups.com <indo-oracle%2540yahoogroups.com>> > > > Sent: Sun, April 25, 2010 10:13:20 AM > > Subject: Re: [indo-oracle] cara melihat komputer A lagi open table > > > > > > select > > > > c.owner, > > > > c.object_name, > > > > c.object_type, > > > > b.sid, > > > > b.serial#, > > > > b.status, > > > > b.osuser, > > > > b.machine > > > > from > > > > v$locked_object a , > > > > v$session b, > > > > dba_objects c > > > > where > > > > b.sid = a.session_id > > > > and > > > > a.object_id = c.object_id; > > > > On 4/24/2010 2:54 AM, fan...@yahoo. co.id wrote: > > > > > > Hello indo-oracle, > > > > > > mau tanya, bagaimana caranya kita bisa tahu komputer A > > > lagi open/select table yang mana > > > tks > > > > > > -- > > > Best regards, > > > fansul > > > mailto:fan...@yahoo. co.id <mailto:fansul% <fansul%25> 40yahoo.co. id> > > > > > > ____________ _________ _________ _________ _________ __ > > > Apakah Anda Yahoo!? > > > Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik > > > terhadap spam > > > http://id.mail. yahoo.com <http://id.mail. yahoo.com> > > > > > > > > > > > > > > > > > > No virus found in this incoming message. > > > Checked by AVG - www.avg.com > > > Version: 9.0.814 / Virus Database: 271.1.1/2831 - Release Date: > > 04/23/10 14:31:00 > > > > > > > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > No virus found in this incoming message. > > Checked by AVG - www.avg.com > > Version: 9.0.814 / Virus Database: 271.1.1/2835 - Release Date: 04/25/10 > 14:31:00 > > > > > > > [Non-text portions of this message have been removed] > > > [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/
