Jupyter Lab installation on Fedora to access an Oracle database Posted on February 14, 2019 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Python 3.7 installation Jupyter Lab installation Jupyter Lab testing References Read more Oracle, Python SQL 1 comment
Minimum required privileges for PL/SQL debugging with SQL Developer Posted on January 16, 2019 , Modified on January 16, 2019 , by Yannick JaquierTable of contents Preamble PL/SQL debugging as object owner PL/SQL debugging with another account References Read more Oracle Security, SQL 2 comments
How to identify table fragmentation and remove it ? Posted on December 18, 2018 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Legacy situation Newest methods to estimate tables size Table fragmentation identification Move, shrink or export/import ? References Read more Oracle SQL, Tuning 11 comments
How to non intrusively find index rebuild or shrink candidates ? Posted on November 23, 2018 , Modified on October 12, 2026 , 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 Read more Oracle SQL, Tuning 3 comments
Simple Oracle Document Access (SODA) installation and usage Posted on November 1, 2018 , Modified on May 28, 2019 , by Yannick JaquierTable of contents Preamble SODA setup SODA testing Collection creation/deletion Managing document in a collection References Read more Oracle Administration, SQL Leave a comment
Oracle REST Data Services (ORDS) installation and usage Posted on October 8, 2018 , Modified on January 23, 2026 , 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 Read more Oracle Administration, SQL 7 comments