第一步:使用top命令查看pid
把pid带入下面两个sql脚本:
查看具体pid的执行sql语句:
SELECT sql_text FROM vsqlareaaWHERE(a.hashvalue,a.address)IN(SELECTDECODE(sqlhashvalue,0,prevhashvalue,sqlhashvalue),DECODE(sqlhashvalue,0,prevsqladdr,sqladdress)FROMvsession b WHERE b.paddr = (SELECT addr FROM vprocesscWHEREc.spid=29276));查看具体pid的机器,用户和状态:selectb.server,b.username,b.sid,b.machineFROMvsession b WHERE b.paddr = (SELECT addr FROM v$process c WHERE c.spid = 29306);
查看某个用户的权限:
select * from dba_role_privs where grantee='zsd';(使用dba权限的用户查看某个用户)
修改用户密码
alter user zsd identified by 1234567_zsd;
把pid带入下面两个sql脚本:
查看具体pid的执行sql语句:
SELECT sql_text FROM vsqlareaaWHERE(a.hashvalue,a.address)IN(SELECTDECODE(sqlhashvalue,0,prevhashvalue,sqlhashvalue),DECODE(sqlhashvalue,0,prevsqladdr,sqladdress)FROMvsession b WHERE b.paddr = (SELECT addr FROM vprocesscWHEREc.spid=29276));查看具体pid的机器,用户和状态:selectb.server,b.username,b.sid,b.machineFROMvsession b WHERE b.paddr = (SELECT addr FROM v$process c WHERE c.spid = 29306);
查看某个用户的权限:
select * from dba_role_privs where grantee='zsd';(使用dba权限的用户查看某个用户)
修改用户密码
alter user zsd identified by 1234567_zsd;