Category: Oracle
-
Unusable and Parallel indexes on Flashback Data Archive Tables in 19.22
After updating to release 19.22, issues arose with Flashback Data Archive (FDA). Despite bug fixes(35957640), internal indexes were created with the DEFAULT PARALLEL degree. Additionally, split operations caused related indexes to become unusable. A debug of the FBDA process revealed that the split operations lack an “UPDATE INDEXES” clause and no index rebuild operation is done internally. The test case provided highlights the issues. These concerns have been raised in a Service Request for resolution.
-
Holistic Patching for Oracle Enterprise Manager
This blog introduces the concept of holistic patching for Oracle Enterprise Manager, which simplifies and consolidates patch management for its various components. The method aims to reduce complexity and downtime by bundling updates into a single package, allowing organizations to focus on core activities. The process involves updating the OMSPatcher and executing a simple command for patching, significantly streamlining the patching process for Enterprise Manager.
-
Create a Function-based Index with NLSSORT
The performance fluctuations in a query on production database were attributed to different NLS_SORT settings affecting SQL plan selection. The query showed varying performance with differing plan_hash_values despite a simple structure. Investigations revealed the impact of NLS settings on plan generation. Mimicking the behavior with setting NLS_SORT value in session confirmed the issue, leading to the creation of a functional index that resolved the problem, as evidenced by the subsequent execution plan.
-
MongoDB Alternatives: FerretDB vs Oracle vs MariaDB as NoSQL Solutions
The One Billion Row Challenge (1BRC) presented by Gunnar Morling invited Java developers to aggregate and summarize a large volume of data. At the PGDay Ankara Conference, Murat Tuncer showcased FerretDB as a seamless alternative to MongoDB, aligning with the trend of “Just use Postgres for everything.” The Oracle MongoDB API and FerretDB allow developers to use MongoDB syntax with relational database management systems. A performance comparison revealed that while both alternatives are capable, they were slightly less efficient than vanilla MongoDB.
-
How to Install Oracle Database API for MongoDB
The installation of Oracle Database 23ai involves downloading the setup file, modifying configuration parameters, creating directories for ORDS, installing and configuring ORDS, creating a database user for MongoDB API, and connecting to the database using mongosh. Various commands are used for these tasks, including downloading and unzipping ORDS, modifying configuration files, and connecting to the database with specified credentials and settings. The process also includes setting custom ports for ORDS and the MongoDB API.
-
“spatial_vector_acceleration” parameter improves Oracle spatial vector query performance
Oracle Database 12c and above introduce significant speed improvements for spatial operations. The SPATIAL_VECTOR_ACCELERATION parameter, set to TRUE, enhances index performance, geometry engine efficiency, and CPU and memory usage. Oracle Spatial and Graph is included in the Oracle Database license at no extra cost. Rebuilding spatial indexes with INDEXTYPE=MDSYS.SPATIAL_INDEX_V2 can simplify index management and improve performance for specific queries.
Osman’s DBlog 