In the previous post ORACLE ACTIVE DATA GUARD 19C FEATURES: AN ASTERISK, using Global Temporary Tables (GTTs) on an Oracle 18c or 19c Active Data
Tag: Oracle Database
Oracle Active Data Guard 19c Features: an asterisk
Using Oracle Active Data Guard (ADG) gets easier to set up every release — you can even use dbca on a new standby for creating
Who moved my cheese parameter?
On databases with multiple DBAs and a not too rigorous change control policy, database parameters get changed and it’s not always clear who made the
What's In A Name? Oracle SQL Developer Can Help You Find Out
What’s in a query block name, that is! I was trying to figure out the intricacies of how the Oracle optimizer works with set operators
Not All Chained Rows Are Created Equal: Exadata to the Rescue Part 2
In Part 1 of this post, I pointed out the key difference between two different types of Oracle chained rows — chained rows that were
PGA: An Often Underutilized Resource. And . . . Exadata.
I’ve noticed on many customer systems that PGA memory is underutilized. With parameters available since Oracle Database 12c Release 1 (12.1.0.1/2) such as PGA_AGGREGATE_LIMIT, you
