How to non intrusively find index rebuild or shrink candidates ? Posted on November 23, 2018, updated on November 28, 2019 by Yannick Jaquier Table 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 Jaquier Table 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 Jaquier Table 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
Application Continuity (AC) for Java – JDBC HA – part 6 Posted on September 13, 2018, updated on May 28, 2019 by Yannick Jaquier Table of contents Preamble Application Continuity (AC) testing Issues encountered No more data to read from socket Closed Connection ORA-41412: results changed during replay; failover cannot continue Diagnostics and Tracing References Continue reading
Transaction Guard (TG) for Java – JDBC HA – part 5 Posted on August 27, 2018, updated on May 28, 2019 by Yannick Jaquier Table of contents Preamble Transaction Guard (TG) testing Issues encountered References Continue reading
Fast Connection Failover (FCF) – JDBC HA – part 4 Posted on August 7, 2018, updated on May 28, 2019 by Yannick Jaquier Table of contents Preamble Fast Connection Failover (FCF) testing Universal Connection Pool (UCP) for JDBC Java testing code Java testing code References Continue reading