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