Recent stories

Improve parsing and query performance - fix Oracle's fixed object statistics


What do I mean by 'fix' the the fixed object statistics? Simply gather statistics to help the optimizer. What are ...

5 min read

Oracle 12c - adaptive query optimization


Scenario: A user complains that a batch job that is critical for the month end business processing is taking more time ...

2 min read