Minimum required privileges for PL/SQL debugging with SQL Developer Posted on January 16, 2019, updated on January 16, 2019 by Yannick JaquierTable of contents Preamble PL/SQL debugging as object owner PL/SQL debugging with another account References Continue reading
How to identify table fragmentation and remove it ? Posted on December 18, 2018, updated on October 16, 2019 by Yannick JaquierTable of contents Preamble Legacy situation Newest methods to estimate tables size Table fragmentation identification Move, shrink or export/import ? References Continue reading
How to non intrusively find index rebuild or shrink candidates ? Posted on November 23, 2018, updated on November 28, 2019 by Yannick JaquierTable of contents Preamble Legacy situation Newest methods to estimate indexes size Index rebuild candidates list To go further Rebuild or shrink ? References Continue reading
Simple Oracle Document Access (SODA) installation and usage Posted on November 1, 2018, updated on May 28, 2019 by Yannick JaquierTable of contents Preamble SODA setup SODA testing Collection creation/deletion Managing document in a collection References Continue reading
Oracle REST Data Services (ORDS) installation and usage Posted on October 8, 2018, updated on May 28, 2019 by Yannick JaquierTable of contents Preamble ORDS installation ORDS setup Automatic Enabling of Schema Objects for REST Access (AutoREST) REST-Enabled SQL Service Configuring Secure Access to RESTful Services First Party Cookie-Based Authentication Third Party OAuth 2.0-Based Authentication ORDS uninstall References Continue reading
Automatic extended statistics to improve performance Posted on April 6, 2017, updated on July 9, 2024 by Yannick JaquierTable of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Continue reading