Oracle DBA simple operation

 

-- SQL statements with many executions

Select SQL _text, executions from (

Select SQL _text, executions from v $ sqlarea order by executions desc

) Where rownum <81;

-- Read SQL statements with multiple hard disks

Select SQL _text, disk_reads from (

Select SQL _text, disk_reads from v $ sqlarea order by disk_reads desc

) Where rownum <21;

--. View All Users:

Select * from dba_users;

Select * from all_users;

Select * from user_users;

-- View system permissions of users or roles (system permissions assigned to users or roles ):

Select * from dba_sys_privs;

Select * from user_sys_privs;

 

-- View permissions of a role (only the roles owned by login users can be viewed)

Select * from role_sys_privs;

 

-- View user object permissions

Select * from dba_tab_privs;

Select * from all_tab_privs;

Select * from user_tab_privs;

 

-- View all roles

Select * from dba_roles;

 

-- View roles owned by a user or role

Select * from dba_role_privs;

Select * from user_role_privs;

 

-- View which users have sysdba or sysoper system permissions (the corresponding permissions are required for query)

Select * from V $ PWFILE_USERS

 

SELECT name, spare4 from sys. USER $ WHERE password is not null;