用户名锁定后,解锁命令 alter user [用户名] account unlock; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 学习了,加个,查看锁表情况SELECT A.OWNER 方案名,A.OBJECT_NAME 表名,B.XIDUSN 回滚段号,B.XIDSLOT 槽号,B.XIDSQN 序列号,B.SESSION_ID 锁表SESSION_ID,B.ORACLE_USERNAME 锁表用户名, decode(D.type,'XR','NULL','RS','SS(Row-S)','CF','SS(Row-S)', 'TM', 'TABLE LOCK', 'PW', 'TABLE LOCK', 'TO', 'TABLE LOCK', 'TS', 'TABLE LOCK', 'RT', 'ROW LOCK', 'TX', 'ROW LOCK','MR','S(Share)',NULL) 锁定方式,UTL_INADDR.GET_HOST_ADDRESS(decode(C.TERMINAL,'unknown','localhost')) IP,C.MACHINE 用户组,C.TERMINAL 机器名,B.OS_USER_NAME 系统用户名,B.PROCESS 系统进程id, DECODE(C.STATUS,'INACTIVE','不活动','ACTIVE','活动') 活动情况 ,C.SERVER,C.SID,C.SERIAL#,C.PROGRAM 连接方式,C.LOGON_TIMEFROM ALL_OBJECTS A,V$LOCKED_OBJECT B,SYS.GV_$SESSION C,v$lock dWHERE ( A.OBJECT_ID = B.OBJECT_ID )AND (B.PROCESS = C.PROCESS )and C.sid = d.sidand B.LOCKED_MODE = D.LMODEORDER BY 1,2; Oracle建立索引时没有指定表空间,那这些索引去哪了,查不到 怎么设置sqlplus 里的行宽 oracle 批量插入 南北软件面试题目。。。。。。。。。。谁能做出来? 学习hadoop之前,最好先学哪些课程 如何关闭oracle的开机自启动 急求ORACLE for SCO UNIX的安装盘 请问oracle在xp专业版下面可以安装吗? 请教oracle developer 的程序制作安装盘的问题!!! tomcat的问题,请各位关注!! 全文检索结果group by性能的问题 数据问题
A.OBJECT_NAME 表名,
B.XIDUSN 回滚段号,
B.XIDSLOT 槽号,
B.XIDSQN 序列号,
B.SESSION_ID 锁表SESSION_ID,
B.ORACLE_USERNAME 锁表用户名,
decode(D.type,'XR','NULL','RS','SS(Row-S)','CF','SS(Row-S)', 'TM', 'TABLE LOCK', 'PW', 'TABLE LOCK', 'TO', 'TABLE LOCK', 'TS', 'TABLE LOCK', 'RT', 'ROW LOCK', 'TX', 'ROW LOCK','MR','S(Share)',NULL) 锁定方式,
UTL_INADDR.GET_HOST_ADDRESS(decode(C.TERMINAL,'unknown','localhost')) IP,
C.MACHINE 用户组,
C.TERMINAL 机器名,
B.OS_USER_NAME 系统用户名,
B.PROCESS 系统进程id,
DECODE(C.STATUS,'INACTIVE','不活动','ACTIVE','活动') 活动情况 ,
C.SERVER,
C.SID,
C.SERIAL#,
C.PROGRAM 连接方式,
C.LOGON_TIME
FROM ALL_OBJECTS A,
V$LOCKED_OBJECT B,
SYS.GV_$SESSION C,
v$lock d
WHERE ( A.OBJECT_ID = B.OBJECT_ID )
AND (B.PROCESS = C.PROCESS )
and C.sid = d.sid
and B.LOCKED_MODE = D.LMODE
ORDER BY 1,2;