Oracle GoldenGate and compressed tables

Oracle GoldenGate does not support reading from compressed tables.  When we asked Oracle about this, the response from Product Management was, “Currently GoldenGate does not support capturing from compressed objects, but it can deliver to compressed objects. It’s on the roadmap but definitely not in the short term.”

Advertisements

Oracle SQL Trace paper by Cary Millsap

Really enjoyed this SQL trace paper by Cary Millsap.

I noticed his footnote on Solaris and microstate accounting, which led me to ask our Unix admins about it. Learned from them that microstate accounting cannot be disabled in Solaris 10, so nice to be able to assume more accuracy on that OS. More info: Sun blog article on microstate accounting in Solaris 10.