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, it will automatically generate redo as well. The methods are: 1) Query V$SESS_IO. This view…
Author: FMunozAlvarez
New Oracle Enterprise Manager 10g Release 5 !!!
Don’t miss the global launch webcast of Oracle Enterprise Manager 10g Release 5, this will be the 03/03/2009 09:00 AM (Pacific Standard Time), to assist please register here. In the webcast you will learn about key new capabilities like: New Siebel 8.1.1 support, New management capabilities for Oracle Beehive and Oracle BRM New monitoring accelerators…
Great News for the APEX Community
The big day for the APEX community is here! The new version of Apex (v3.2) is now available for download here. (The apex_3.2.zip file size is only 97.3M) For New features, please refer to here. For New APEX 3.2 Oracle by Examples, please refer to here. Oracle Application Express 3.2 is supported on all Standard and Enterprise Edition…
New Oracle ACE Director
I’m very proud to announce that this morning I’ve been awarded the Oracle ACE Director status, an Oracle ACE Director is someone who is not only recognized for past efforts and achievements but is also willing to commit themselves to ongoing participation and involvement in assisting the Oracle community. I’d like to thank Lillian Buziak for…
Forms to APEX, Finally coming soon…
Finnaly we are able to test and check the new release of APEX (3.2), this version will enable you to load your Oracle Forms and Report source into an Oracle Application Express project and generate an initial APEX application. To see more about this and other release 3.2 new features details, please click here! Currently Oracle Application Express…
Auckland Lantern Festival, Chinese New Year Celebrations
As one of Auckland’s most popular summer events, the Auckland Lantern Festival brings Chinese New Year celebrations to a glowing finale with hundreds of beautiful lanterns, including brand new designs from China, some performers from New Zealand and overseas, as well as crafts, fortune-telling, fireworks and martial arts displays. 2009 is the Year of the Ox,…
Installing Grid Control – Part I
By Francisco Munoz Alvarez Before you start with an installation of Grid Control, I’ll recommend you to go thru the documentation to understand all the minimum requirements and the installation process. For reference purpose, I’ll resume some important points of it here. Let’s start taking a close look in the components of the Grid Control …
CLOUG, new Challenge
Until last Thursday I was the Vice President of CLOUG (Chilean Oracle Users Group, www.cloug.org), but by request of the members I was now elected president of CLOUG. This will be a big challenge due to the distance between my primary house and my birth country (over 10.000 km), but I love it, and I’ll keep…
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 file sync’. Oracle foreground processes wait for ‘log file sync’ whereas the LGWR process waits…
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 for query or REF CURSOR parameter ORA-06512: at “SYS.DBMS_XMLGEN”, line 83 ORA-06512: at “SYS.DBMS_METADATA”, line…