Reducing cluster waits by Granville Bonyata
If you’re seeing high cluster waits because you have multiple processes all inserting into the same set of tables, the cluster waits are resolved by pointing to a single node on the cluster. But just pointing to a single node defeats the rollover benefits of running on RAC. To that end, Oracle gives us Services … Read more
Hotsos Symposium Speaker 2011
I will be speaking at Hotsos Symposium 2011 which will be held March 6 — 10, 2011 at the Omni Mandalay Hotel in Irving, TX. Presentation Title Oracle Diagnostic Events Abstract Oracle 11g has a completely new low-level kernel diagnostics and tracing infrastructure built into it. This presentation will explore new diagnostic events. I will … Read more
Network Time Protocol ( NTP ) & Clusterware diagnostic script
One of the prerequisites to successfully install Oracle version 11.2 is to set Network Time Protocol ( NTP ) ( file /etc/sysconfig/ntpd ) with -x flag which prevents time from adjusting backward. This comes very crucial in debugging Oracle Clusterware.NTP will synchronize clocks among all nodes which will make correct analysis of trace files based … Read more
MOS notes – Troubleshooting ASM
I just summarized few notes that I have used for troubleshooting ASM. Placeholder for AMDU binaries and using with ASM 10g [ID 553639.1] ASMIOSTAT Script to collect iostats for ASM disks [ID 437996.1] Information to gather when diagnosing ASM space issues [ID 351117.1] and of course you can always dump ASM block using SQL> alter … Read more
Oracle 11.2.0.2 Patch Set and new patching strategy
Once again Oracle changed patching strategy. Starting with the 11.2.0.2 patch set, Oracle Database patch sets are full installations of the Oracle Database software. This means that you do not need to install Oracle Database 11g Release 2 (11.2.0.1) before installing Oracle Database 11g Release 2 (11.2.0.2). Note the following changes with the new patch … Read more
