1. Installing Xfce on Oracle Linux 9
Martin Bach shares, “This post explains how to install Xfce on Oracle Linux 9.4 x86-64 using the EPEL (Extra Packages for Enterprise Linux) repository. I’m fairly sure the same applies to ARM64 as well, but I didn’t have time to test. The article is based on the latest ISO image from https://yum.oracle.com/oracle-linux-isos.html. I installed a minimum system, and applied all the patches I could get my hands on until June 24th 2024.
2. The age of AI with Oracle GoldenGate23ai
Artificial Intelligence (AI) is buzzing in today’s enterprise circles. This blog briefly examine susing AI in data integration, specifically with Oracle GoldenGate and then goes on to outline the benefits of AI in data integration.
3. 23ai, new parameters DB_FLASHBACK_LOG_DEST_SIZE and DB_FLASHBACK_LOG_DEST
Fernando Simon writes:
“Oracle database has the Oracle Flashback Technology that allows you to view old images of your data without the need to restore your database. You can use restore points, restore tables, and rows, and do a lot of things. To use it (in a simple way), you need to enable the archivelog and flashback mode for your database and Oracle will create additional logs while you change the data.
Unfortunately, it is exactly these logs that create some issues. Jonathan Lewis already described this issue, and in resume, while changing the data you need to write more because you will use UNDO + Flashback logs. In essence, you write more every time.
He then goes on to explain:
- How it works
- How to use it
- Just archivelogs
- Archivelogs and Flashback logs at Fast Recovery Area
- Setting the DB_FLASHBACK_LOG_DEST_SIZE and DB_FLASHBACK_LOG_DEST
4. OCI Data Flow: ETL with Apache Spark in the Cloud
Janis Rumnieks writes about:
- About OCI Data Flow
- The Setup
- The Code
- Challenges
- Conclusion
5. JSON Relational Duality view & API for an ‘EMPLOYEES’ entity
Jeff Smith asks, “Remember our friendly Human Resources (HR) schema? And in that schema, remember our EMPLOYEES table? And it has that awesome self-referential key constraint, tying the manager_ID back to an existing employee_ID?”
6. Get Ready for Oracle CloudWorld 2024
Enjoy this video:
7. How to Resize Block Volumes of Linux Instances Online via the OCI Console
And this one:
8. Load a SQL Plan with its Plan Hash Value into SQL Plan Baseline
This blog starts with:
“As a seasoned database administrator, I’m no stranger to the quirks and challenges of maintaining a high-performing database environment. Recently, I encountered a situation that many of you might find familiar: the need to load a specific SQL execution plan into a SQL Plan Baseline using its plan hash value. Let’s dive into this topic and unravel the steps together, adding a sprinkle of fun along the way!”
9. Oracle Cloud Infrastructure – Resource Scheduler First Release
Martin Berger links to this documentation
This blog starts with:
“The first part of this series showed how you can leverage Oracle’s SQL syntax with UDT columns and collection columns. It would be nice if Oracle gave you some SQL to work with the elements of ADT collections, but they don’t. After all, that’s why you have this article.
While you could change the setup of the prior example table, it’s easier to create a new customer table. The new customer table drops the address column. There’s also a new pizza table. The pizza table includes an ingredient ADT collection column, which by design holds a unique set of ingredients for each pizza.
Realistically, ADT collections of numbers, characters, and dates have little value by themselves. That’s because those data types typically don’t have much meaning. A set of unique strings can be useful for certain use cases.”