Oracle 数据库锁机制及性能监控脚本

--oracle收回dba权限语句
--revoke dba from username
--username用户没有DBA权限的情况下，需要添加的权限。
 
grant select on SYS.V_$LOCK to username;
grant select on SYS.V_$LOCKED_OBJECT to username;
grant select on SYS.V_$LOCKS_WITH_COLLISIONS to username;
grant select on SYS.V_$LOCK_ACTIVITY to username;
grant select on SYS.V_$LOCK_ELEMENT to username;
grant select on SYS.V_$LOCK_TYPE to username;
grant select on SYS.V_$OPEN_CURSOR to username;
grant select on SYS.V_$PROCESS to username;
grant select on SYS.V_$PROCESS_MEMORY to username;
grant select on SYS.V_$PROCESS_MEMORY_DETAIL to username;
grant select on SYS.V_$PROCESS_MEMORY_DETAIL_PROG to username;
grant select on SYS.V_$SESSION to username;
grant select on SYS.V_$SESSION_CONNECT_INFO to username;
grant select on SYS.V_$SESSION_CURSOR_CACHE to username;
grant select on SYS.V_$SESSION_EVENT to username;
--grant select on SYS.V_$SESSION_FIX_CONTROL to username;
grant select on SYS.V_$SESSION_LONGOPS to username;
grant select on SYS.V_$SESSION_OBJECT_CACHE to username;
grant select on SYS.V_$SESSION_WAIT to username;
grant select on SYS.V_$SESSION_WAIT_CLASS to username;
grant select on SYS.V_$SESSION_WAIT_HISTORY to username;
grant select on SYS.V_$SESSTAT to username;
grant select on SYS.V_$SORT_SEGMENT to username;
grant select on SYS.V_$SORT_USAGE to username;
grant select on SYS.V_$SQL to username;
grant select on SYS.V_$SQLAREA to username;