1. Using Spatial Studio to Extend / Enhance Dimensions for OAC
Wayne D Van Sluys writes, “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.”
He walks us through an example step-by-step.
He concludes by saying, “I hope this example shows how easy it is to use Spatial Studio to help extend dimensions and create hierarchical geographic data.”
2. Optimising Journal Line Queries: 5. Conclusion
This blog is is the last of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN).
- Conclusion
- Problem Statement
- Exadata System Statistics
- Partitioning
- Compression
3. Oracle Cloud EPM – Renaming Stuff
Eric Erikson writes, “Like most people I’m learning new things in Oracle Cloud EPM all the time. Many items (probably like this one) are most likely things that others have known for years and take for granted. Anyway, here is something I recently ran across that’s a followup to my February 2025 post about migrating away from Financial Reporting.”
4. Creating Database Domain on SuperCluster and Installing Cluster Database with OEDA
Erman Arslan introduces this blog with, “Today, we will take a look at the Supercluster side of things. That is, setting up a new Database Domain on Oracle Super Cluster M8 and performing a Cluster Database installation using the Oracle Exadata Deployment Assistant (OEDA) tool.”
5. Oracle Apps : Query to get the Position details of an employee in R12.1.3
Anoop Johny’s blog is a query that gives the details of an employee’s current position in Oracle Apps R12.1.3.
6. Oracle DB MCP server – Oracle SQLcl, few links
This blog shares several useful links, including this video:
7. Oracle database predicate mistakes – 23ai SQL Analysis Report
This blog concludes with, “The last predicate issue here is that we are asking for all values except one. Well, that is probably most of the table, so it’s positive that an index will not get used. This may be unavoidable based on what the query needs to return. Sometimes that just will be the case, and hopefully the other two fixes and usage of indexes will make the SQL perform well enough.
I don’t we have fully fixed this query, but I do hope this explanation of the issues and usage of the new SQL Analysis Report helps your understanding.”
8. Upgrade Enterprise Manager to 24ai
Alfredo Krieg shares, “In this post I want to share my experience while executing the upgrade of Oracle Enterprise Manager from 13.5 to 24ai.
As always. Please go ahead and read the Oracle documentation on how to upgrade EM to 24ai.”
Brendan Tierney writes, “New in Oracle 23ai is a feature to allow tracking and monitoring the last 50 queries per session. Previously, we had other features and tools for doing this, but with SQL History we have some of this information in one location. SQL History will not replace what you’ve been using previously, but is just another tool to assist you in your monitoring and diagnostics. Each user can access their own current session history, while SQL and DBAs can view the history of all current user sessions…”
10. Beware of Mixed Mode in Unified Auditing Being Turned Off
Pete Finnigan warns about Mixed Mode. He says, “Be aware of this if you create unified policies without enabling pure mode. If the standard audit is disabled then so is your Unified audit trail!”