Infrastructure at your Service

Category

Oracle

Franck Pachot

Do you use SQL Plan Baselines?

By | Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . I can hear a lot of complaints about the instability coming from the adaptive features introduced into the optimizer logic at each release. Giving more intelligence to the optimizer is very good to improve the response time for generated queries, BI, ad-hoc reporting. But when you have an OLTP that works for years with its static set of queries, then you don’t appreciate the plan instability coming from (in reverse chronological…

Read More
Franck Pachot

You are in Standard Edition One? Don’t worry.

By | Database Administration & Monitoring, Oracle | 24 Comments

By Franck Pachot . You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to do things manually, have maintenance windows. You are ok with a RTO of 5 minutes (time to switchover with Dbvisit standby), RPO of 10 minutes (archive_lag_target=600). Your servers have no more than 2 sockets. So…

Read More
Franck Pachot

set state=apply-off and datafile consistency

By | Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a consistent state? We know the answer, but want to prove it. This is the kind of question you may have, as I did last Friday morning in the train with Ludovico Caldara when going to…

Read More