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 Continue reading
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 Continue reading
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 Continue reading
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, Continue reading
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 Continue reading
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 Continue reading
Here are some pictures from our current family vacation in the NZ south island. Happy 2009, Francisco Munoz Alvarez