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 April 6, 2017 by Yannick JaquierTable of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Continue reading
How to submit an external script with Oracle scheduler Posted on October 25, 2016, updated on October 25, 2016 by Yannick JaquierTable of contents Preamble Oracle scheduler external job References Continue reading
Incremental statistics on partitioned tables Posted on June 29, 2016, updated on June 29, 2016 by Yannick JaquierTable of contents Preamble Incremental statistics Results References Continue reading
Aggregated global statistics on partitioned tables or not ? Posted on June 1, 2016, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Partitioned test table Aggregated global statistics Gathered global statistics Global statistics performance comparison References Continue reading