Databases@Powered by Passion

  • LANGUAGE_MISMATCH - shared cursor

    Create a Function-based Index with NLSSORT

    —

    by

    Osman DİNÇ
    , ,

    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.

  • Installation Steps of MariaDB NoSQL Protocol

    Installing MariaDB and Configuring MaxScale NoSQL Protocol Module on Oracle Linux 8

    —

    by

    Osman DİNÇ
    , ,

    The post details the installation and configuration of MariaDB and MaxScale with the NoSQL Protocol Module on Oracle Linux 8. The process involves downloading and installing MariaDB 11.4.2, configuring the MariaDB repositories for YUM, installing dependencies, setting up MaxScale as a database proxy, and establishing a NoSQL Listener. After verifying the services, the user prepares to interact with the NoSQL Protocol Module for MariaDB.

  • Comparison of MongoDb and Mongo APIs

    MongoDB Alternatives: FerretDB vs Oracle vs MariaDB as NoSQL Solutions

    —

    by

    Osman DİNÇ
    , , ,

    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.

  • Oracle Database API for MongoDB Configuration

    How to Install Oracle Database API for MongoDB

    —

    by

    Osman DİNÇ
    ,

    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.

  • FerretDB Installation on Oracle Linux

    Installing FerretDB Using PostgreSQL as the Database Engine

    —

    by

    Osman DİNÇ
    ,

    FerretDB is an open-source proxy that converts MongoDB 5.0+ wire protocol queries to SQL, using PostgreSQL or SQLite as a database engine. It functions as a drop-in replacement for MongoDB and is constantly updated to enhance compatibility and performance. Installation involves downloading the RPM package, configuring it to listen on port 27002, setting up PostgreSQL, modifying its settings, creating a database, and starting FerretDB. Utilizes PostgreSQL as the backend.

  • Installation steps of MongoDB on Oracle Linux

    MongoDB Community Version Installation on Oracle Linux Server

    —

    by

    Osman DİNÇ
    , ,

    The content provided outlines the step-by-step process for installing MongoDB community edition 7.0.9 on Oracle Linux Server release 8.7. It includes details on verifying and changing the default kernel, adding the MongoDB repository, configuring MongoDB settings, disabling SELinux, setting up MongoDB services, and creating a MongoDB user with admin privileges. Additionally, it covers addressing transparent hugepages and configuring memory map areas.