Onur Ardahnli began with, “In today’s article, we will discuss checking for LOCKs in the
database, which is one of the checks we perform when there is a problem in the database.”
This blog goes through two different scenarios and concludes with:
“Wrangling the effects of forgotten processes generating audit data does take some initial effort and planning, but the work expended is well worth the time when it prevents surprise space issues rearing their ugly heads. Regular monitoring also makes maintenance simpler and faster as unwieldy data volumes are unlikely to occur, which keeps stress levels low.”
3. Using Oracle’s Autonomous Health Framework to get an “Insight” into a RAC Cluster
This blog links to this video demonstration.
4. 3 Workflow Enhancements in EDM 24.10 That You Can Use Now!
Kate Helmer posted about several updates and enhancements across the Oracle EDM & EPM platform.
5. Exporting Oracle Rest Data Services metrics for Prometheus
This blog begins with:
“ORDS documentation has a chapter how to push ORDS metrics to OpenTelemetry endpoint, which also is supported by Prometheus. But Prometheus traditionally is using the opposite method, that Prometheus itself will regularly connect to monitored service endpoints and scrape all its metrics. Similar JavaAgent method can also be deployed to expose ORDS metrics as a traditional Prometheus pull based endpoint.”
Jonathan Lewis shares:
“Many years ago I wrote a short note to introduce the view v$sql_optimizer_env (and the session and system equivalents) which report the current values of optimizer related parameters (some of which are not found in the startup file) for a cursor child, or a session, or the system. I also mentioned the underlying x$kqlfsqce (for v$sql_optimizer_env) that held far more parameters than were reported in the v$ view.
Recently I commented on a question about different plans (i.e. child cursors) for the same query for different sessions and noted that changing the optimizer_features_enable might not change any of the visible (v$) parameters – other than optimizer_features_enable itself – so it might be necessary to check the x$ to find out what had changed. Here’s a possible query to do that, followed by a few lines of output.”
7. Using the PL/SQL Profiler in the Oracle Autonomous Database
Julian Dontcheff says, “The PL/SQL (Hierarchical) Profiler has been part of the Oracle database for quite some time but there is very little, close to none, information on how to use it in the Oracle Autonomous Database.
This blog post is about how to bypass few hurdles in the Autonomous database for we lack OS access in ADB-S.”
8. Avoiding MLE/JavaScript pitfalls: the requested module does not provide an export named ‘default’
Martin Carstenbach summarises:
“When importing JavaScript modules in your own code, pay attention to how to do so. Some modules, particularly those provided via community repositories, might require you to import the default export. The popular validator module is a good example. Others offer named exports, which you find documented alongside the code. What’s a named export I head you ask? That a way to import a specific thing from a JavaScript module.”
Mark Rittman begins this blog by saying:
“Google BigQuery recently introduced a pre-GA preview of Contribution Analysis, an BQML feature designed to help analysts uncover the drivers of change in key business metrics. By comparing test and control datasets, Contribution Analysis identifies which segments-defined by combinations of attributes like region, channel, or promotion type-have the most statistically significant impact on the metric being evaluated.”
10. Can I convert a non-CDB into a CDB?
Mike Dietrich asks, “Can I convert a non-CDB into a CDB?”
His short answer is ‘no’. But he goes onto explain.