Monthly Archives: January 2009

LOGGING or NOLOGGING, that is the question – Part VII

By Francisco Munoz Alvarez Redo Logging I/O-Related Wait Events There are a number of Wait Events that happen during Redo Logging activities and most of them are I/O-related. The two most important ones are ‘log file parallel write’ and ‘log

Posted in Redo Logs

How to solve the error “EXP-00056: ORACLE error 19206″ during an export

If you see the error EXP-00056 with Oracle error 19206 (like show bellow) when executing a export of an entire schema in Oracle 9i or 10g, don’t panic. The solution is easy. EXP-00056: ORACLE error 19206 encountered ORA-19206: Invalid value

Posted in General, Oracle FAQ

LOGGING or NOLOGGING, that is the question – Part VI

 By Francisco Munoz Alvarez TIPS USING NOLOGGING MODE  DIRECT PATH INSERT  To use Direct Path Insert use the /*+ APPEND */ hint as follow: INSERT /*+ APPEND */ into … SELECT … When direct path insert is used oracle does

Posted in Redo Logs, Tutorials, White Papers

Call for papers – CLOUG 2009 – April 13-14 2009

Hi all We are opening the call for papers for the first CLOUG (Chilean Oracle Users Group) National Conference at Santiago, Chile. Topics we are particularly interested in hearing , but not limited to: – Database – Developer; Forms, JDeveloper,

Posted in News

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

Some good time with the Family

Here are some pictures from our current family vacation in the NZ south island. Happy 2009, Francisco Munoz Alvarez

Posted in General