Category: Oracle
-
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.
-
Oracle Database Patching by Using Ansible
This post discusses using Ansible Playbooks to patch Oracle database software, from installing Ansible to completing the patching process. It provides detailed playbooks for creating new database software directories, applying release updates and one-off patches, running datapatch, and removing old database homes. The author also revised the playbooks for better readability and compatibility.
-
Oracle Grid Patching by using Ansible
This blog post discusses the usage of Redhat Ansible to patch grid infrastructure, emphasizing its simplicity and efficiency. It explains the process of installing Ansible, preparing the environment, and executing playbooks for grid software patching with detailed steps. The author also provides valuable insights into the revision of playbooks for best practices.
Osman’s DBlog 