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
Mr Trace
Mr Trace speaks for itself. Cary Millsap and the and Method R created a great add-in to Oracle SQL Developer. It’s called Method R Trace .When you run your PL/SQL code, it automatically turns tracing on and off at the right times, fetches the trace file for you, and presents it in a list right … Read more
Creating 11.2.0.2 using DBCA
DBCA needs to include sizes in G Bytes for Fast Recovery Area.Mb are too small these days.. If you pick Automatic Memory Management DBCA will stop you from using more memory than it is size of tmpfs /dev/shm.That is a good feature but although I specified correct amount of memory database creation failed.After looking … Read more
Visitors to this site
