1.Connection to Oracle Autonomous Database In this blog, Selvakumar Nagulan explains how to connect to an Oracle Autonomous database using SQL developer, SQL plus or other tools. He refers to this document in his blog. 2. Reading a LOB in another session Martin Berger begins by saying, “Reading a LOB in…
Tag: news
Weekly Update w/c 4th March 2024
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…
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 – December 2023
Some of the best blogs I’ve read in the last month or so: This blog begins with, “I started some home lab cleanup this long weekend, and one of the first steps was to set up a separate DNS server for the lab. This is really just to make it…
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…
Monthly Round Up
Blogs of the Month 1.How to study for 1z0-1067-23 – Oracle Cloud Infrastructure 2023 Cloud Operations Professional In this blog, Alex Zaballa gives some vital tips on what to focus on for the Oracle Cloud Infrastructure 2023 Cloud Operations Professional. He suggests you focus on: He also includes some handy…
Monthly Round Up
Blogs of the month Here’s 10 of the best from the last few weeks: 1.Enabling Search Framework Real Time Indexing (RTI) Jim Marion writes, “As we prepare our HCM PUM 46 training servers, we decided to enable Real Time Indexing (RTI). We found several great sample videos and resources but still made…
What’s New?
Blogs of the month 1. OEM: ASH Package Version Status – manual update In the Performance Hub page, it can show a yellow warning sign (⚠️) Read the blog to find out how to fix it! 2. Document Data Extraction – Data Mapping for Donut Model Fine-Tuning Dataset (Document AI)…
What’s going on this February?
Blogs of the month Patching my environments with the January 2023 Bundle Patches Mike Dietrich shares information about January’s Security Alert and gives a quick overview of the patch bundles he intends to apply to his 19c and 21c environments. 2. Fixing up oem 11g This blog begins with, “Although oracle enterprise…