Tuning

When converting a database from one operating system to another one (to phase out your Itanium infrastructure for example) you may be tempted to play with parallelism parameter when converting your tablespaces (having one datafile in our example). This RMAN convert phase is obviously needed when your destination platform endian format is not he same:

InnoDB plugin versus built-in InnoDB

Posted on February 21, 2011, updated on March 26, 2021 by Yannick Jaquier

Deferred statistics publishing

Posted on February 4, 2011, updated on June 25, 2015 by Yannick Jaquier

Server result cache to improve performance by holding result sets

Posted on January 21, 2011, updated on May 2, 2018 by Yannick Jaquier

IT World

Tuning

DBMS_SQLTUNE concrete example

Table of contents

RMAN and TDPO performance testing

Table of contents

RMAN convert optimization

InnoDB plugin versus built-in InnoDB

Table of contents

Deferred statistics publishing

Table of contents

Server result cache to improve performance by holding result sets

Table of contents