Radu Pârvu

Notes on tech, tools, and thinking

    Welcome to Radu Parvu’s site on tech and news of the world!

    UPDATE: Release Schedule of Current Database Releases (Doc ID 742060.1)

    19c

    • UPDATE: Release Schedule of Current Database Releases (Doc ID 742060.1)

      UPDATE: Release Schedule of Current Database Releases (Doc ID 742060.1)

      The release schedule for current database updates has been updated. Upgrade support for versions 11.2, 12.1, and 12.2 has been extended through 2026, ensuring continued assistance and maintenance for users of these database versions. For further details, refer to Doc ID 742060.1.

    • Oracle 19c Lab Setup: Essential Steps on VMWare Fusion

      Oracle 19c Lab Setup: Essential Steps on VMWare Fusion

      This document outlines the steps for installing Oracle Enterprise Linux 8 and Oracle Database 19c on VMware Fusion. Key procedures include configuring network settings, enabling SSH, and installing open-vm-tools. Post-installation tasks involve setting up authentication for the oracle user, configuring firewall ports, and preparing the environment for database operations.

    • Control DDL Commands in Oracle Databases

      Control DDL Commands in Oracle Databases

      This article discusses implementing a database-level trigger to manage and restrict DDL operations by limiting access to specific users. Unauthorized users attempting DDL actions will encounter a custom error message. The trigger code is provided, along with examples of error stacks generated from prohibited actions such as adding a column or truncating a table. This…

    • How to Detect Unused PL/SQL Objects in Oracle

      How to Detect Unused PL/SQL Objects in Oracle

      To identify unused PL/SQL code in an Oracle database, several methods are recommended. Strategies include auditing PL/SQL execution, using DBA_DEPENDENCIES views to track dependencies, and analyzing execution data through DBMS_PROFILER. A process for safely removing unused code should be established, including renaming suspected units and ensuring backups before deletion.

    • Understanding RAC One Node: Benefits and Drawbacks

      Understanding RAC One Node: Benefits and Drawbacks

      RAC OneNode is an Oracle RAC feature that allows a single database instance on one node with easy relocation options. It enhances high availability and simplifies management but is less effective for heavy workloads and multi-node performance. Its complexities in licensing and potential downtime during relocations are notable drawbacks.

    • Top Factors for Oracle Database Migration Success

      Top Factors for Oracle Database Migration Success

      To migrate Oracle database instances to Oracle Database on Azure, key criteria include database size, workload characteristics, version compatibility, application dependencies, performance requirements, high availability, security compliance, current infrastructure, customization complexity, migration strategy feasibility, backup procedures, and cost implications. Assessing these ensures effective migration planning.

    • Best Practices: Data Migration using Oracle datapump

      Best Practices: Data Migration using Oracle datapump

      This article emphasizes common mistakes clients make in data migration strategies using Oracle datapump. Instead of risking the migration process with large data dumps, the author suggests a strategy to ensure the success of data migration. This includes validating all constraints, refraining from exporting certain database elements, and running jobs in interactive mode. The article…

    • SQLcl: Setup on a Mac

      SQLcl: Setup on a Mac

      Simple and straightforward steps about how to setup Oracle’s new SQL command line tool on a macOS X environment. Download Application and Environment Setup Attempt to start the application: Setup Java Download Java from the Oracle site. As I am on a mac wit M processor (ARM) , I cannot install jre-8u371-macosx-x64.dmg, so I cannot…

    • Problematic Statistics of the Application Objects in your Oracle Database

      Problematic Statistics of the Application Objects in your Oracle Database

      One of the often asked questions is to find out the status of the statistics of the application owned schemas. In this article, I will list the SQL code that I used for this purpose. As well, I will publish a SQL Developer report that can be used for the same purpose. For ease of…

    • Oracle Automated DB Maintenance Tasks

      Oracle Automated DB Maintenance Tasks

      This is a short article on how to manage the automated Oracle database maintenance tasks. Make sure the needed rights are in place by running the check: Typical output is: If your user is not listed, you must grant EXECUTE in order to use the package: We can check what is enabled by running: With…

    • Comparing Oracle Databases: Initialization Parameters

      Comparing Oracle Databases: Initialization Parameters

      A method for comparing the Oracle init parameters of several PDB’s

    • CTAS Performance II: TESTING

      CTAS Performance II: TESTING

      Testing variants of CTAS