Monthly Archives: 10月 2011

Oracle中查看锁表情况的Sql语句

2011-10-30 by Jinyang | No Comments | Filed in Oracle

SELECT S.SID SESSION_ID, S.USERNAME, DECODE(LMODE,0,’None’,1,’Null’,2,’Row-S (SS)’, 3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6,’Exclusive’,TO_CHAR(LMODE)) MODE_HELD, DECODE(REQUEST,0,’None’,1,’Null’,2,’Row-S (SS)’,3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6, ‘Exclusive’,TO_CHAR(REQUEST)) MODE_REQUESTED, O.OWNER||’.’||O.OBJECT_NAME||'(‘||O.OBJECT_TYPE||’)’, S.TYPE LOCK_TYPE, L.ID1 LOCK_ID1, L.ID2 LOCK_ID2 FROM  V$LOCK L, SYS.DBA_OBJECTS O, V$SESSION S WHERE  L.SID  =  S.SID  AND   L.ID1  =  O. OBJECT_ID; SELECT S.SID SESSION_ID, S.USERNAME, DECODE(LMODE,0,’None’,1,’Null’,2,’Row-S (SS)’,  3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6,’Exclusive’,TO_CHAR(LMODE)) MODE_HELD,   DECODE(REQUEST,0,’None’,1,’Null’,2,’Row-S (SS)’,3,’Row-X (SX)’,4,’Share’,5,’S/Row-X (SSX)’,6, […]

第二次竞价:Bid history for ningzhi.com

2011-10-24 by Jinyang | No Comments | Filed in 域名

Bid History Bid history for ningzhi.com 23-Oct-2011 15:18 PDT Bidder Date Bid Amount Comment gnotes 23-Oct-2011 13:31 PDT $557.00 Completed gnotes 23-Oct-2011 12:39 PDT $557.00 Bid Placed yuminame 23-Oct-2011 12:30 PDT $532.00 Bid Placed gnotes 23-Oct-2011 12:28 PDT $507.00 Bid Placed yuminame 23-Oct-2011 12:28 PDT $501.00 Bid Placed yuminame 23-Oct-2011 12:25 PDT $476.00 Bid Placed […]

Tags:

Bid history for ningzhi.com

2011-10-07 by Jinyang | No Comments | Filed in 域名

其实没什么人竞价的,我没打算要,就随便抬了下价格,早早的出了个价就休息了,这个兄弟破费了,还不错的域名 Bid history for ningzhi.com Starting Bid: $69.00 07-Oct-2011 01:58 PDT Bidder Date Bid Amount Comment domainreg081 05-Oct-2011 23:58 PDT $583.00 Bid Placed istu 05-Oct-2011 18:21 PDT $558.00 Bid Placed domainreg081 05-Oct-2011 05:41 PDT $533.00 Bid Placed istu 05-Oct-2011 05:41 PDT $508.00 Bid Placed domainreg081 05-Oct-2011 04:40 PDT $458.00 Bid Placed istu 05-Oct-2011 04:40 PDT $433.00 […]

Tags:

返回顶部