Radu Pârvu

Notes on tech, tools, and thinking

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

    watch Command in Unix

    recipe

    • watch Command in Unix

      watch Command in Unix

      The content outlines the use of the “watch” command to monitor an Oracle ZDM migration process on Azure. It demonstrates how to query job status at regular intervals, providing details about the job ID, user, type, execution times, and system metrics. The command’s functionality enhances visibility into the migration process.

    • 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.

    • What to do when a process uses too much CPU

      What to do when a process uses too much CPU

      The spinning beachball, a juddery interface, and fans running full pelt: what’s CPU doing in Activity Monitor, and what should you do about it? What to do when a process uses too much CPU

    • SQLcl: Customizing on a Mac

      SQLcl: Customizing on a Mac

      In this post I will summarize the steps I’ve taken to customize SQLcl on my Mac working environment. We assume that the reader is familiar with the procedures outline din my previous post on SQLcl on setting up SQLcl on Mac environment. Terminal customization First I start with changing the terminal a bit in order…

    • 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…

    • Comparing Oracle Databases: Initialization Parameters

      Comparing Oracle Databases: Initialization Parameters

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

    • Column Level Collation Example

      Column Level Collation Example

      The feature was first introduced in 12.2 . It basically determines how the string comparison takes place. In order to use the feature, extended data types should be enabled.

    • Starting Oracle SQL Developer with Custom Parameters

      Starting Oracle SQL Developer with Custom Parameters

      I recently worked at a Client that had the Windows desktop setup in a non-English language. Naturally, I did not get admin rights on the Client owned desktop so I could not change the sqldeveloper.conf SQL Developer config file which was stored in a ‘protected’ location.

    • Setup a VirtualBox based Database Lab Environment

      Setup a VirtualBox based Database Lab Environment

      Oracle provides a lot of useful Oracle VirtualBox Pre-built Appliances. In this blog post, I will describe the few extra steps I take after download in order to setup my lab environment on my work MacBook Pro.

    • How to monitor SQL with Oracle SQL Developer

      The easiest way to monitor the SQL’s currently executing

    • SQL*Plus Client connections to several Oracle Autonomous (Always-Free)

      SQL*Plus Client connections to several Oracle Autonomous (Always-Free)

      Oracle Autonomous is a great service and Always-Free is a nice offering launched at OpenWorld 2019. But what happens if I need to connect via SQL*Plus to two or more ADB from the same machine/terminal? The Oracle documentation provides good reference usable when connectiong to one autonomous database but if we need to use several…