将查询的结果生成到文件中:
强行杀session:
SELECT DISTINCT '(' || s.sid || ') - ' || username AS "(session) - username",
o.kglnaobj FROM V$SESSION s, sys.x$kglob o, sys.x$kglpn p WHERE upper(o.kglnaobj) LIKE ('%P_CREATE_TABLE_ZJ_USER_INFO%') AND p.kglpnhdl = o.kglhdadr AND s.SADDR =
select spid, osuser, s.program
from v$session s,v$process p
where s.paddr=p.addr and s.sid in(53);
查看表空间信息:
查看回滚段信息: