Category Archive: Internals

Jan 23

ORA 600 [kcbAdoptBuffers_pw]

We hit this bug the other day. The oracle note references creating an index as part of this bug. As far as I can tell, we weren’t doing that when we hit this. It is a vendor application though, and I know they do some DDL such as creating tables on the fly. I was …

Continue reading »

Mar 08

HOTSOS In Texas!

I am currently in Texas at the HOTSOS Symposium. I look forward to this conference every year. There are some brilliant people here, and it is a great place to learn new things. Kerry Osborn did a great live presentation yesterday, can’t wait to get home and try some of this stuff out. Also saw …

Continue reading »

Nov 17

Where Are My Nodes?

I should mention the current setup is a 4 node RAC┬ádatabase with a dataguard managed standby comprised of a 3 node RAC database cluster. The current database version is 11.2.0.4 While writing a shell script today, I needed to know from connecting to a database in a cluster what all the related nodes were. This …

Continue reading »