ORACLE DBA常用脚本

--查询当前连接数
select count(*) from v$process;
--查询总连接数
select value from v$parameter where name = 'processes';
--查询当前连接的用户
select * from user_role_privs;
--查询用户是否被锁
select USERNAME , ACCOUNT_STATUS from dba_users;
--查锁语句
SELECT s.username,
       l.OBJECT_ID,
       l.SESSION_ID,
       a.object_name,
       s.SERIAL#,
       l.ORACLE_USERNAME,
       l.OS_USER_NAME,
       s.machine,
       l.PROCESS,
       l.LOCKED_MODE,
       B.SQL_TEXT
  FROM V$LOCKED_OBJECT l, V$SESSION S, all_objects A, V$SQL B
 WHERE l.SESSION_ID = S.SID
   AND l.OBJECT_ID = a.object_id
   AND s.SQL_ADDRESS = B.ADDRESS
   AND s.SQL_HASH_VALUE = B.HASH_VALUE
   AND S.SQL_ID = B.SQL_ID
   AND S.SQL_CHILD_NUMBER = B.CHILD_NUMBER
--查询连接用户
select sid,serial#,username,program,machine,status
   　　from v$session