OracleNZ by Francisco Munoz Alvarez
Knowledge is only valuable if shared!
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 LOGGING or NOLOGGING, that is the question – Part VII
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 How to solve the error “EXP-00056: ORACLE error 19206″ during an export
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 LOGGING or NOLOGGING, that is the question – Part VI
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 Call for papers – CLOUG 2009 – April 13-14 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 Continue reading Oracle CPU (Critical Patch Update) January-2009
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 Be a hero, be proactive!
Here are some pictures from our current family vacation in the NZ south island. Happy 2009, Francisco Munoz Alvarez