Securefiles LOB and Database File System (DBFS) hands-on Posted on September 30, 2013, updated on May 29, 2019 by Yannick JaquierTable of contents Preamble Basicfiles LOBs Securefiles LOBs Migration from basicfiles LOBs to securefiles LOBs DBFS References Continue reading
Can Recycle Bin impact performance ? Posted on August 30, 2013, updated on August 7, 2015 by Yannick JaquierTable of contents Preamble How recycle bin comes in loop References Continue reading
Database hanging for high version count and SYS_REFCURSOR usage Posted on June 5, 2013, updated on March 26, 2021 by Yannick JaquierTable of contents Initial problem First solution and second problem Second solution 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
Pipelined functions Posted on May 23, 2012, updated on March 1, 2021 by Yannick JaquierTable of contents Preamble Pipelined functions creation References Continue reading
Server result cache to improve performance by holding result sets Posted on January 21, 2011, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Server result cache Manual mode Force mode Table annotations PL/SQL function result cache Client result cache References Continue reading