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 you can extract metric data from the Monitoring service. This metric extraction is really useful when you need to integrate the Monitoring service with 3rd party tools.
He goes through:
- Prerequisites
- List Metrics
- Query Metric Data
3. Export from 11g and import to 19c
In this article, we learn how to export from 11g and import to 19c.
The Oracle DATA PUMP is a very powerful tool and using the Export and Import method, we can load the from the lower Oracle database version to the higher Oracle Database version and vice versa.
4. OCI Data Labeling using Bounding Box
Brendan Tierney focuses in this blog on creating a new labeled dataset using bounding boxes, and in a later post, we’ll examine the resulting model to see if it gives better or more accurate results.
In a previous post, he gave examples of how to label data using OCI Data Labeling. It was a simple approach to data labeling images for input to AI Vision. In that post, we just gave a label for the image to indicate if the image contained a Cat or a Dog.
Pete Finnegan shares a presentation about Oracle Database Password Security here.
6. Accounts Payable Transaction in Oracle Cloud FSCM
Himanshu Chaubey shares a flowchart and step by step instructions in this blog.
7. How to Migrate Your On-Prem MySQL 8 Database to RDS Using MySQL Shell Logical Backup
Igor Donchovski begins his blog by writing:
“AWS RDS (fully managed relational database service) for MySQL is becoming increasingly popular, and so are the migration headaches when you have a very large database. I recently worked on a project to migrate a 2 TB MySQL 8 database to AWS RDS and wanted to share some details on how to do it using MySQL Shell.
There are several migration options, like AWS DMS, xtrabackup, mydumper/myloader, or even mysqldump. However, the new MySQL Shell tool offers many advantages.”
8. Behind the Error Message: Solving row_count package bug in dbt
This blog by Tatum Brannan explores the issue, that in a dbt project within Big Query, a problem occurs when utilizing the dbt_utils.equal_rowcount package.
This problem surfaces when one of the tables being compared is empty, as the test is not equipped to handle such scenarios within Big Query.
Read the full blog to work out what to do.
9. Oracle and Microsoft expand partnership to deliver Oracle database services in Azure
Karan Batta asks, “Organizations want choice, and nearly all of them are using two or more clouds. But, most workloads are still on-premises, and many of them are Oracle Database workloads. Why?”
10. Using ROWID for efficient parallel execution
Connor McDonald starts by saying, “As far back as 11g, a nifty tool for “manual” parallel processing is the DBMS_PARALLEL_EXECUTE package. In a nutshell, the basic premise is that for tasks that do not naturally fit into Oracle’s standard parallel processing DML/DDL options, you can use the package to break a large task into a smaller number of tasks that will be executed in parallel using the job scheduler in the database. It is nothing that you could not build yourself manually, but having a pre-packaged routine to do it just makes it all easier.”