Oracle DBA常用命令

Sysdba身份登录数据库:

sqlplus sys/[password]@[TNSNAME] as sysdba

sqlplus sys/a@DEV as sysdba

 

查看DB中的schema

select username from dba_users;

 

查看schema上连接的session

select saddr,sid,serial#,paddr,username,status from v$session where username='RO_GEM_DEV';

 

查询有死锁的session

SELECT A.OWNER, 
       A.OBJECT_NAME, 
       B.XIDUSN, 
       B.XIDSLOT, 
       B.XIDSQN, 
       B.SESSION_ID, 
       B.ORACLE_USERNAME, 
       B.OS_USER_NAME, 
       B.PROCESS, 
       B.LOCKED_MODE, 
       C.MACHINE, 
       C.STATUS, 
       C.SERVER, 
       C.SID, 
       C.SERIAL#, 
       C.PROGRAM 
  FROM ALL_OBJECTS A, V$LOCKED_OBJECT B, SYS.GV_$SESSION C 
 WHERE (A.OBJECT_ID = B.OBJECT_ID) 
   AND (B.PROCESS = C.PROCESS)

 

Kill Session

alter system kill session '133,55448';