Blogs of the month
Here’s 10 of the best from the last few weeks:
1.Enabling Search Framework Real Time Indexing (RTI)
Jim Marion writes, “As we prepare our HCM PUM 46 training servers, we decided to enable Real Time Indexing (RTI). We found several great sample videos and resources but still made a few mistakes. We are sharing our adventure to help you as you implement RTI.”
He also includes the following resources in his blog:
2. How To CREATE a DATABASE in PostgreSQL
This blog begins by saying:
“In this comprehensive guide, I will demonstrate the step-by-step process of setting up a database in PostgreSQL. By following these instructions, you will gain a solid understanding of how to create a database in PostgreSQL effectively.”
He also shares this video:
3. OGG Veridata Bundle Patch 12.2.1.4.220831 (PS4 BP6)
This blog links to this post.
4. Oracle Database 23c Free Developer Release on OKE with Portworx Essentials – Part 2
In this 2-part blog series, Ron Ekins writes, “In this Blog Series I am going to share how to deploy the Oracle Database 23c Free Developer Release on an Oracle Cloud Infrastructure (OCI) Oracle Container Engine for Kubernetes (OKE) Cluster with Portworx storage.”
This blog begins by saying:
“I’ve introduced a new feature in dbalarm script to clear all flashback logs whenever the Flash Recovery Area (FRA) hits its defined threshold “FRATHRESHOLD” inside the script. This is the first optional corrective action I include in dbalarm monitoring script. I may add more optional corrective actions in the future if I feel it was easy understood and utilized by DBAs.
I feel that since Oracle 10g, Oracle has a chronic problem with cleaning up FLASHBACK Logs FLBs whenever FRA becomes full, this is why I’m targeting the cleanup of FLBs in this feature.”
6. Audit Log – Showing Internal References
Eric Erikson gives a heads up on an issue with the audit log. “When a member is moved from one parent to another, the audit log captures that and shows the “from member” and “to member.” Only, it doesn’t. What shows is an internal reference, which isn’t helpful in determining the member labels that are seen in the application.”
7. Using Spatial Studio to Extend / Enhance Dimensions for OAC
Wayne D Van Sluys says, “Oracle Spatial Studio is a great tool that can be leveraged to extend or enhance location based data you may already be working with in your analytic projects.
Say you would like to define sales regions that are based on counties within the state and you would like to view those regions on a map.
Here is a publicly available map of Missouri, the task is to create 6 sales regions so that sale can be tracked by region and then be able to drill into region to see the sales by county for that region.”
8. Building Your Own ChatGPT Plugin
Andrej Baranovskij says, “It is essential to understand how to define OpenAPI specification to match endpoints. In this example, you will see a working use case with endpoints providing info on uploading a file and then fetching file data into ChatGPT.”
9. Combine your data with unions using three best practices
Gabrielle Prichard says, “Oracle Analytics Cloud (OAC) data flows provide the ability to merge datasets in data preparation workflows. Combining data through a union presents several benefits including:
- Merging data from disparate data sources into a unified dataset
- Increasing dataset size by merging information from different time periods, geographical locations, product areas, and so on
- Reducing data duplication by eliminating repeated records
- Creating datasets with only common records among input datasets
This article focuses on the best practices for combining datasets with unions so that you can effectively use this feature. If you’re interested in learning about the different union types supported in OAC (Union All, Union, Intersect, among others) with several examples, visit this blog.”
10. Oracle Data Guard Vs Oracle Active Data Guard
Helios writes, “Oracle Data Guard and Active Data Guard… Both are super cool solutions for high availability and disaster recovery solutions. However, they differ in terms of their capabilities and functionalities.
You need to be Enterprise Edition version to can use Data Guard. Just reminder, Oracle Data Guard bundle with Oracle EE license. You need to license Active Data Guard.
So as I said, Oracle Data Guard and Active Data Guard are both features of Oracle Database that provide high availability and disaster recovery solutions. However, they differ in terms of their capabilities and functionalities.
Lets dig in this topic.”
Read the whole blog here.