Blog Archives

My book: Oracle Database 12c Backup and Recovery Survival Guide

It was a long journey of hard work and team work that now has finished, as a result you will find my book Oracle Database 12c Backup and Recovery Survival Guide that I wrote with the help of my good

Posted in 12c, Backup & Recovery, Books, DBA Career Tips, General, Interview Tips, Others, Questions, Scripts, Tutorials, White Papers

Tip of the month – Magic for DBAs

Who never had a problem with a SQL that is killing your Database Performance and you can’t fix it because it’s running from an external closed application that you or your developers can’t touch? Since Oracle version 10 this is

Posted in General, Oracle FAQ, Tuning, Tutorials

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,

Posted in General, Interview Tips, Monitoring, Questions, Redo Logs, Scripts, Tuning

Oracle CPU (Critical Patch Update) January-2009

The first CPU of 2009 is already out,  was released on January 13, 2009. Like always, Oracle strongly recommends applying the patches as soon as possible.  To know more about  the January CPU like products and components affected, please refer

Posted in News, Security

Be a hero, be proactive!

Let start this New Year with a new mentality or a new resolution if you prefer call this way, let stop being reactive and start being proactive. Being proactive will reduce your database administration costs and increase your level of

Posted in DBA Career Tips, Monitoring, Oracle FAQ, Scripts, Tuning

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

Posted in Oracle FAQ, Questions, Security

How to setup a Basic Audit?

For any Oracle versions prior to 9i you will need to set audit_trail parameter in the pfile ie.g.: audit_trail = DB For later Oracle Versions: SQL>alter system set audit_trail = DB; To enable auditing for a specific object run the

Posted in Oracle FAQ, Questions, Security