摘要:
1.V$LOGFILE.STATUS (http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1152.htm#sthref3730) 类型:VARCHAR2(7) Status of the log member: 1.INVALID - File is inaccessible(文... 阅读全文
摘要:
select distinct t2.username,t2.sid,t2.serial#,t2.logon_time,t2.terminal
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time 阅读全文