Tuesday, July 24, 2012
AUTO LOG WITH TRIGGER
create
TRIGGER TRIG_MYTBL_LOG AFTER
UPDATE ON MYTBL FOR EACH ROW BEGIN
INSERT
INTO MYTBL_LOG
(
ITEM_CODE,
GTIN,
REGID,
REGIP,
REGDATE
)
VALUES
(
:OLD.ITEM_CODE,
:OLD.GTIN,
:OLD.REGID,
:OLD.REGIP,
:OLD.REGDATE
);
END;
Labels:
oracle
Tuesday, July 17, 2012
How to Delete all .svn folders using Windows Command Prompt
You can use the following command to delete all .svn folders in curent directory recursively.
FOR /R . %f IN (.svn) DO RD /s /q %f
Share Article : How to Delete all .svn folders using Windows Command Prompt
How to Delete all .svn folders using Windows Command Prompt
Saturday, July 14, 2012
Friday, March 9, 2012
Killing an Oracle session to remove a LOCK
Get List of LOCKS
SELECT l.inst_id,
SUBSTR(L.ORACLE_USERNAME,1,8) ORA_USER,
SUBSTR(L.SESSION_ID,1,3) SID,
S.serial#,
SUBSTR(O.OWNER||'.'||O.OBJECT_NAME,1,40) OBJECT, P.SPID OS_PID,
DECODE(L.LOCKED_MODE, 0,'NONE',
1,'NULL',
2,'ROW SHARE',
3,'ROW EXCLUSIVE',
4,'SHARE',
5,'SHARE ROW EXCLUSIVE',
6,'EXCLUSIVE',
NULL) LOCK_MODE
FROM sys.GV_$LOCKED_OBJECT L
, DBA_OBJECTS O
, sys.GV_$SESSION S
, sys.GV_$PROCESS P
WHERE L.OBJECT_ID = O.OBJECT_ID
and l.inst_id = s.inst_id
AND L.SESSION_ID = S.SID
and s.inst_id = p.inst_id
AND S.PADDR = P.ADDR(+)
order by l.inst_id
Just a matter of Killing
ALTER SYSTEM KILL SESSION 'sid#,serial#' IMMEDIATE;
Share Article : Killing an Oracle session to remove a LOCK
Killing an Oracle session to remove a LOCK
Subscribe to:
Posts (Atom)


