Blogs of the Month
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:
- What and how you can move Cross-region
- Budgets and Alerts
- What is related to Compartments and what is related to the Tenancy
- Upload and Download files using the cli and the console
- NVMe – Performance and how to protect
- Object Storage life cycle
He also includes some handy links.
Ron Ekins shares Part 3 in a blog series. In this one, he shows you to use the MySQL Shell to dump a MySQL 8 database to an S3 Compatible Object Storage bucket.
This post begins by telling you How to Start!
It is full of handy links with blogs, tutorials and installation guides.
There are also links to a video page with helpful videos such as:
This blog begins with, “I had a request from one of the adjunct professors to connect SQL Developer to the PostgreSQL database. This is in support of our database programming class that teaches students how to write PL/SQL against the Oracle database and pgPL/SQL against the PostgreSQL database. We also demonstrate transactional management through Node.js, Python and Java.
Naturally, this is also a frequent step taken by those required to migrate PostgreSQL data models to an Oracle database. While my final solution requires mimicking Oracle’s database user to schema, it does work for migration purposes. I’ll update this post when I determine how to populate the database drop-down list.”
Andrejus Baranovskij links his blog to the following video:
Pete Finnegan shares: “I had an email from an Oracle colleague a few days ago asking me a question about Oracle Unified Audit in 19c. He wanted to be able to track when someone with the DBA role accesses objects in a particular schema and no one else and also when someone accesses the same schema objects with SYSDBA, RSYSRAC, SYSOPER etc and no one else.
He wanted to know if there is any trick to set object audit in Unified Audit so that instead of “select on orablog.table” could we do “select on schema.*” or similar for all privileges he wants to track on the objects such as insert, update, delete, select and execute.”
Brendan Tierney writes, “One of the new PL/SQL packages with Oracle 23c is DBMS_SEARCH. This can be used for indexing (and searching) multiple schema objects in a single index.
Check out the documentation for DBMS_SEARCH.
This type of index is a little different to your traditional index. With DBMS_SEARCH we can create an index across multiple schema objects using just a single index. This gives us greater indexing capabilities for scenarios where we need to search data across multiple objects. You can create a ubiquitous search index on multiple columns of a table or multiple columns from different tables in a given schema. All done using one index, rather than having to use multiples. Because of this wider search capability, you will see this (DBMS_SEARCH) being referred to as a Ubiquitous Search Index. A ubiquitous search index is a JSON search index and can be used for full-text and range-based searches.”
Ludovico shares about an article he saw published on the AWS architecture blog. His central message is:
If you need to implement a complex architecture using a software solution, pay attention that the practices suggested by the partner/integrator/3rd party match the ones from the software vendor. In the case of Oracle Data Guard, Oracle knows better 😉
Christopher Johnson refers to a previous post. He says that, “it was well received and I got a bunch of Slacks and emails about it. And I figured if there was that much interest in one of the ways we manage our tenancy there would probably be interest in some of the other ways we keep things on the straight and narrow here.”
Alfredo Kriegdba says, “Monitoring Oracle Standby Database (Data Guard) has been always a tricky task. Just by the nature of them (the fact that the instance is not open in read-write mode) is hard to gather information about them. Even using specialized tools like Oracle Enterprise Manager requires SYSDBA credentials in order to effectively monitor them. But what about when running them on OCI?”