LOGGING or NOLOGGING, that is the question – Part VIII

By Francisco Munoz Alvarez How to find Sessions Generating Lots of Redo To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, Continue reading

How to find all user Roles and Privileges?

Here is the scripts to help you to get this information: PROMPT  PROMPT  PROMPT ******************************************** ROLES AND PRIVILEGES  PROMPT  PROMPT ******************************************** USER ROLES  SELECT grantee user, granted_role, admin_option, default_role  FROM dba_role_privs  WHERE grantee IN (SELECT username FROM dba_users) AND       grantee Continue reading