1. Oracle ASM Filter Driver (AFD) Filtering and 5.15 UEK7 kernels
Ron shares the background:
“As a long time fan of the Oracle ASM Filer Driver, one of the major benefits for Oracle ASM Filter Driver (AFD) is AFD Filtering.
AFD can ensure writes are only performed by trusted and registered Oracle processes, blocking potentially damaging writes that would have otherwise resulted in data corruption.
Unfortunately, a recent Linux kernel change has impacted the AFD and the latest recommendation from Oracle is to disable AFD Filtering until a fix is available…”
In this blog post he explores the impact of disabling AFD Filtering on space reclamation on all-flash storage arrays.
2. Top 10 Linux Commands for Monitoring and Troubleshooting Your System
Read this blog for some top Linux commands.
3. How to identify which indexes can be safely dropped in Oracle
This blog begins with, “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 dropped can be tricky…”
Maria adds an update on this blog:
“There have been several comments on this post around what each of the columns in the DBA_INDEX_USAGE view actual record and Jonathan Lewis has written a great explanation of each column in the view in the first part of his blog series on Index Usage.”
4. How to Optimise ODI Performance with the Right Knowledge Modules
Berta writes, “In this article, we’ll explore some optimisation techniques specifically tailored for Oracle Data Integrator (ODI), a leading ETL tool.
We’ll cover the following:
- Gather Statistics
- Choice of Knowledge Module
- Customising Knowledge Modules to disable/enable indexes
5. Downloading Oracle Patches using CLI with AutoUpgrade Patching
Rodrigo Jorge writes, “Since October 2024, the Oracle Database Upgrade team has made many improvements in AutoUpgrade Patching. The most expressive one is adding the capability for it to connect on MOS, download patches automatically, create a new Oracle home with all those patches applied, and finally move the database from the old Oracle home to a new Oracle home.
However, if your database server has no internet connectivity (what is expected) even via proxy, you can download patches on a different server or your own notebook and later moved them to a shared NFS server that this server has access to, for example. In this article, we will check how this can be performed with AutoUpgrade Patching on 3 different hosts: MacOS, Windows and Linux.”
6. Automating Code Reviews with Git Hooks and Oracle Generative AI
This blog by James Walsh demonstrates how we can use Oracle Generative AI to automate peer reviews for files being committed to a Git repository. This approach is not only efficient but also leverages AI’s strengths in identifying performance issues, security vulnerabilities, and style inconsistencies.
7. How to upload multiple files in 1 call: multipart/form-data
Jeff Smith asks, “One of my more popular posts on ORDS and REST APIs here is how to upload files. And in fact, I’ve written like 3-4 versions or variations of that post, but I think this is probably the best one:
Definitive example for REST API to add a record to a table
In that example, we do a single row insert with one of the columns being a FILE which is stored in a BLOB.
But, what if you want to make a single HTTP request to upload…multiple ‘things?’”
8. Addressing Query Slowness in PostgreSQL: A Comprehensive Guide
This blog starts with, “In my previous blog post, we delved into the impact of Re-Indexing to boost database performance. Again, Experiencing slow queries in PostgreSQL can be frustrating, especially when they disrupt the performance of your applications. Fortunately, there are several strategies to identify and resolve the root causes of query slowness. Below, I’ve compiled some key recommendations to help you optimize query performance in your PostgreSQL database.”
9. Generating Activity Guide URLs
Jim Marion writes,
“Creating Activity Guide navigation is challenging for two reasons:
Activity Guides with Runtime Context require dynamically generated URLs. These Activity Guides cannot leverage simple content references.
Simple Fluid Activity Guides all use the same component. This means we can’t use a simple content reference. To use security to show or hide an Activity Guide content reference, we must use the URL type of PeopleSoft Generic URL. We must type a PeopleSoft URL fragment rather than leverage the traditional Content Reference fields (menu, component, market).”
This blog starts with, “This was principally written for my SQL students but I thought it might be useful to others.”