4
Do execution plans stay the same if optimizer statistics are not regathered?

Do execution plans stay the same if optimizer statistics are not ...

Nigel Bayliss 2 minute read
Migrating to Oracle Autonomous Database with Real-time SPM

Migrating to Oracle Autonomous Database with Real-time SPM

Nigel Bayliss 6 minute read
What is Real-time SQL plan Management?

What is Real-time SQL plan Management?

Nigel Bayliss 6 minute read
License Change for Automatic SQL Plan Management (yes, you can do more)

License Change for Automatic SQL Plan Management (yes, you can do ...

Nigel Bayliss 1 minute read

Search Oracle Blogs

Receive the latest blog updates

Recent Posts

What is the automatic SQL tuning set?

What is the automatic SQL tuning set?

Nigel Bayliss 1 minute read
What is automatic SQL plan management and why should you care?

What is automatic SQL plan management and why should you care?

Nigel Bayliss 5 minute read
Plan Plan Stability in Oracle Database Standard Edition

Plan Plan Stability in Oracle Database Standard Edition

Nigel Bayliss 1 minute read
What is the difference between SQL Profiles and SQL Plan Baselines?

What is the difference between SQL Profiles and SQL Plan Baselines?

Nigel Bayliss 3 minute read
What’s the Difference Between SPM Auto Capture and Auto SPM?

What’s the Difference Between SPM Auto Capture and Auto SPM?

Nigel Bayliss 1 minute read
Copy an Execution Plan From One SQL Statement to Another using SQL Plan Baselines

Copy an Execution Plan From One SQL Statement to Another using SQL ...

Nigel Bayliss 6 minute read
Fetch First Rows Just Got Faster

Fetch First Rows Just Got Faster

Nigel Bayliss 1 minute read
What is Hint Usage Reporting?

What is Hint Usage Reporting?

Nigel Bayliss 2 minute read
Repairing SQL Performance Regression with SQL Plan Management

Repairing SQL Performance Regression with SQL Plan Management

Nigel Bayliss 3 minute read
Are my SQL plan baselines being re-enabled?

Are my SQL plan baselines being re-enabled?

Nigel Bayliss 5 minute read
Locked Optimizer Statistics – A Useful Tool in Your Toolbox

Locked Optimizer Statistics – A Useful Tool in Your Toolbox

Nigel Bayliss 4 minute read
What should I set ESTIMATE_PERCENT to?

What should I set ESTIMATE_PERCENT to?

Nigel Bayliss 1 minute read

Receive the latest blog updates

Resources for
Why Oracle
Learn
What's New
Contact Us