Category: Oracle
-
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.
-
TOAD and sqlplus have Different Execution Plans: Bind variable peeking
The post discusses a performance issue where an identical query yields different execution plans in TOAD and sqlplus due to various factors such as statistics, physical differences, settings, and OCI commands. The issue is identified as related to Adaptive Cursor Sharing (ACS), and the difference in behavior is observed when running the query with different bind values. The response also mentions a change in TOAD’s OCI Array Buffers size option, resolving the issue in the upcoming beta release.
