Active Session History visualization with Matplotlib and Altair Posted on March 13, 2019, updated on March 13, 2019 by Yannick Jaquier Table of contents Preamble Active Session History visualization with Altair Active Session History visualization with Matplotlib References Continue reading
Jupyter Lab installation on Fedora to access an Oracle database Posted on February 14, 2019, updated on February 14, 2019 by Yannick Jaquier Table of contents Preamble Python 3.7 installation Jupyter Lab installation Jupyter Lab testing References Continue reading
Minimum required privileges for PL/SQL debugging with SQL Developer Posted on January 16, 2019, updated on January 16, 2019 by Yannick Jaquier Table 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 December 24, 2018 by Yannick Jaquier Table 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 23, 2018 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 November 1, 2018 by Yannick Jaquier Table of contents Preamble SODA setup SODA testing Collection creation/deletion Managing document in a collection References Continue reading