0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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 file…
Month: January 2009
How to solve the error “EXP-00056: ORACLE error 19206″ during an export
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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 for…
LOGGING or NOLOGGING, that is the question – Part VI
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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 the…
Call for papers – CLOUG 2009 – April 13-14 2009
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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, J2EE,…
Oracle CPU (Critical Patch Update) January-2009
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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 to…
Be a hero, be proactive!
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email 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 efficiency,…
Some good time with the Family
0 Shares 0 Facebook 0 Twitter 0 Linkedin 0 Facebook-messenger 0 Whatsapp 0 Email Here are some pictures from our current family vacation in the NZ south island. Happy 2009, Francisco Munoz Alvarez