Radu Pârvu

Notes on tech, tools, and thinking

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

    How to Detect Unused PL/SQL Objects in Oracle

    Autonomous

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

    • Oracle Database: Constraints Tutorial

      Oracle Database: Constraints Tutorial

      This article compiles various queries and code blocks used to manage disabled constraints in a database schema. It includes SQL statements to identify and enable these constraints. The content will be updated regularly with new insights, and it lists the tested database versions, starting with Oracle Database 23ai.

    • Ensuring PL/SQL Code Integrity with Checksums

      Ensuring PL/SQL Code Integrity with Checksums

      The content explains how to implement a checksum for PL/SQL procedures to detect unauthorized modifications. It details steps for generating a checksum using Oracle’s DBMS_CRYPTO, storing it for future verification, and comparing it against current values. This approach helps ensure the integrity of PL/SQL procedures over time.

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

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

    • How to monitor SQL with Oracle SQL Developer

      The easiest way to monitor the SQL’s currently executing

    • I am speaking at SPOUG20

      I am speaking at SPOUG20

      Autonomous Database is the best Cloud Database but many Clients wonder about its security! This talk will address those concerns! Oracle Autonomous Database might be the answer to the most database security challenges. In this presentation, I will walk through the way the Oracle’s Autonomous database products protect against the security threats. By design. We…

    • Is Oracle Autonomous Database the answer to the many database security issues? (II)

      Is Oracle Autonomous Database the answer to the many database security issues? (II)

      In the previous article, I discussed the main differentiating capabilities of the Autonomous, what makes it special on the market. In this post, I will discuss how are those capabilities implemented.

    • Is Oracle Autonomous Database the answer to the many database security issues? (I)

      Is Oracle Autonomous Database the answer to the many database security issues? (I)

      There is no surprise that typical Database setups are the main target of the hacking attacks worldwide. The reason is obvious: cracking a database will result in access to the data which is the main ‘merchandise’ to be shared or sold on the dark corners of the World Wide Web.

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

    • It is now possible to clone a database in Autonomous Cloud

      It is now possible to clone a database in Autonomous Cloud

      Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud.