Maria Colgan shared, “The longer an application has been successfully run, the more likely you are to have indexes that are no longer used or beneficial. Removing these indexes not only saves space but can also improve the performance of any DML operations. But knowing which indexes can be safely…
Category: Cloud
Weekly Update – w/c February 19th
In this blog, Atul Kumar covers: 2. Using server-side JavaScript in APEX processes Martin Bach writes, “In this installment of the mini-series you will learn how to write more complex server-side logic using MLE/JavaScript ECMAScript modules.” He goes through: 3. Oracle Sharding methods compared to YugabyteDB Franck Pachot begins his blog…
Weekly update
Neil Chandler begins this blog with, “Gathering object statistic in Oracle is important. The optimizer needs metadata about the object, such as the amount of rows and number of distinct values in a column, to help it decide the optimum way to access your data. This takes effort, and takes…
Monthly Round Up – October 2023
Blogs of the Week This blog centres around the new Oracle Cloud Infrastructure (OCI) Product Tours page. This is the analytics section The page also features links to useful YouTube videos. 2. Extract OCI Monitoring Metrics Using REST APIs Alfredo Krieg shares how you can list metric definitions and how…
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
Autumn Days…
Blogs of the month 1.10 Best Database Management Software of 2021 (+ Examples) This blog lists the Best Database Management Software as: ManageEngine Applications Manager DBeaver Raima Database Manager Valentina Redis Enterprise DbVisualizer Oracle Database Database Labs Sadas Engine Percona Monitoring and Management and gives an extensive overview of each….