Securefiles LOB and Database File System (DBFS) hands-on Posted on September 30, 2013 , Modified on July 2, 2026 , by Yannick JaquierTable of contents Preamble Basicfiles LOBs Securefiles LOBs Migration from basicfiles LOBs to securefiles LOBs DBFS References Read more Oracle Compression, Security, SQL Leave a comment
Can Recycle Bin impact performance ? Posted on August 30, 2013 , Modified on August 7, 2015 , by Yannick JaquierTable of contents Preamble How recycle bin comes in loop References Read more Oracle SQL, Tuning Leave a comment
Database hanging for high version count and SYS_REFCURSOR usage Posted on June 5, 2013 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Initial problem First solution and second problem Second solution References Read more Oracle SQL, Tuning Leave a comment
AWR baselines and performance comparison Posted on May 8, 2013 , Modified on November 13, 2024 , by Yannick JaquierTable of contents Preamble Good performance Bad performance Performance improved Conclusion References Read more Oracle Automatic Workload Repository (AWR), Tuning 1 comment
Media recovery with NOLOGGING tables Posted on March 15, 2013 , Modified 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 Read more Oracle Backup, Data Recovery Advisor Leave a comment
Moving from UTL_FILE_DIR to directories implementation Posted on January 29, 2013 , Modified on February 9, 2018 , by Yannick JaquierTable of contents Preamble UTL_FILE_DIR Directories Read more Oracle SQL 2 comments