Posts by Lakshmikanth Raja

Optimizing Oracle Data Guard: Reducing Archive Logs & Apply Lag

Issue  On an Active Data Guard configuration, we noticed periods where archive log generation on the primary spiked well above normal, and the standby’s apply lag grew along with it.…

Read More

Boosting Analytic Query Performance with Oracle Database In-Memory

Introduction   A set of reporting and analytic queries against a large, frequently scanned table were taking longer than expected, with a large share of the response time going into repeated buffer cache…

Read More