Skip to content
Oracle Analytics by Adrian Ward
Oracle Analytics by Adrian Ward

25 Years Experience and Counting

  • Analytics Performance
  • My Profile
  • Publications
  • 5 Minutes of Fame
  • News Posts
  • Technical Posts
Oracle Analytics by Adrian Ward

25 Years Experience and Counting

December Musings

Posted on December 3, 2024 By Adrian Ward

1. Lock Control in Database

    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.”

    2. Spring Cleaning

    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.”

    6. Optimizer Environment 2

    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.”

    9. Discover the Underlying Drivers of Multichannel Retail Sales Performance with BigQuery BQML Contribution Analysis and Looker Studio

    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.

      Share this:

      • Facebook
      • X
      Analytics Monthly News OBIEE Oracle Oracle Analytics Weekly News obieeOracle AnalyticsOracle Databaseoracleanalytics

      Post navigation

      Previous post
      Next post
      ©2025 Oracle Analytics by Adrian Ward | WordPress Theme by SuperbThemes