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.
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:
- List Metrics
- Query Metric Data
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.
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.
Himanshu Chaubey shares a flowchart and step by step instructions in this blog.
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.”
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.
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?”
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.”