MySQL 5.6 and MySQL 5.5 performance comparison Posted on April 12, 2013, updated on August 7, 2015 by Yannick JaquierTable of contents Preamble Configuration Performance comparison results and conclusion References Continue reading
Media recovery with NOLOGGING tables Posted on March 15, 2013, updated on November 23, 2015 by Yannick JaquierTable of contents Preamble Nologging and CTAS Nologging and insert command Tablespaces logging attributes RMAN and nologging operations References Continue reading
Tmpfs vs Ramfs vs (Transparent) Huge Pages Posted on February 28, 2013, updated on February 16, 2018 by Yannick JaquierTable of contents Preamble Tmpfs Ramfs Huge Pages Transparent Huge Pages (THP) References Continue reading
Have you recently taken your SQL Server backups ? Posted on February 12, 2013, updated on June 25, 2015 by Yannick JaquierTable of contents Available SQL Server backups References Continue reading
Moving from UTL_FILE_DIR to directories implementation Posted on January 29, 2013, updated on February 9, 2018 by Yannick JaquierTable of contents Preamble UTL_FILE_DIR Directories Continue reading
New 11gR2 relink command Posted on December 10, 2012, updated on January 26, 2016 by Yannick JaquierTable of contents Preamble Solutions Dedicated oraInst.loc file Overwrite oraInst.loc with variables References Continue reading