Fine-Grained Access Control (FGAC) hands-on Posted on November 15, 2013, updated on November 1, 2016 by Yannick JaquierTable of contents Preamble Test data model Fine-Grained Access Control (FGAC) implementation Fine-Grained Access Control (FGAC) with application context References Continue reading
Fine-Grained Auditing (FGA) hands-on Posted on October 24, 2013, updated on January 13, 2014 by Yannick JaquierTable of contents Preamble Test data model Default auditing Fine-Grained Auditing (FGA) implementation Fine-Grained Auditing (FGA) reporting Audit cleaning References Continue reading
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
AWR baselines and performance comparison Posted on May 8, 2013, updated on March 14, 2019 by Yannick JaquierTable of contents Preamble Good performance Bad performance Performance improved Conclusion References Continue reading