« 2008年03月 | ??? | 2008年05月 »
ServerType?VAR?VARCHAR2?ORATYPE_RAW_BIN?ORAPARM_OUTPUT??????????
??????128????
MinimumSize????????????????????????
[VB??]
OraDatabase.Parameters.Add "ret", 0, ORAPARM_OUTPUT
Set pret = OraDatabase.Parameters("ret")
pret.ServerType = ORATYPE_VARCHAR2
pret.MinimumSize = 1024
????????????
???????????????
?????????
??????????
???
????????????????
??????????????????????????
??????????????????????????
????????????
?????????????
????
????????????????????????????
??????
??V$LOCK?V$SESSION??SID?SERIAL#?????
SELECT SID, SERIAL#,USERNAME,STATUS,MACHINE,PROGRAM
FROM V$SESSION
WHERE SID IN (
SELECT SID
FROM V$LOCK
WHERE TYPE IN ('TM','TX')
);
??????????
ALTER SYSTEM KILL SESSION 'SID,SERIAL#'???ALTER SYSTEM KILL SESSION '10,5000';
????????????
????????????????
????????????????
?????
????????????????
?????????????????????????????????
??????????
????????????
????????
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 |