Radu Pârvu

Notes on tech, tools, and thinking

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

    Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans

    Oracle

    • Using DBMS_XPLAN.DISPLAY_CURSOR to examine execution plans

      Very nicely explained by sqlmaria / Maria Colgan in the YouTube clip below. Clear and clean. I repost this as a reference and will add more later, if needed.

    • Tuesday Post: Database schemas compare

      One of the questions that arise during the development process is if the database schéma I work on is an unaltered image of production. How do I know that another developer didn’t experiment with a new index or modified the structure of some table? Writing scripts to compare my current database with the ‘source of…

    • Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available

      We published two updates last night, both maintenance releases, aka bug fixes only. Released January 19, 2022.That being said, everyone should … Oracle SQL Developer 21.4.2 & SQLcl 21.4.1 are now available

    • Help, my Oracle SQL Developer is crashing!

      With 7,000,000 users, give or take a million, I get quite a few notes from folks who are having problems getting SQL Developer to open, or to STAY … Help, my Oracle SQL Developer is crashing!

    • Manage Sessions in Oracle Database

      Manage Sessions in Oracle Database

      Review of methods to manage Oracle Database sessions

    • Overview: SELECT SAMPLE

      Overview: SELECT SAMPLE

      One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works.

    • Estimate Defragmentaton Benefits for a Bigfile Tablespace

      Estimate Defragmentaton Benefits for a Bigfile Tablespace

      Database: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production Version 19.3.0.0.0 I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a way to estimate the space benefits of defragmenting the tablespace. I will use two methods.

    • Oracle ULS

      Oracle ULS

      My experience using Oracle’s Unlimited Learning Subscription

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

    • I speak at SPOUG ’21

      I speak at SPOUG ’21

      Oracle Autonomous and Data Lake Accelerator Below you can see the details of your session, including the scheduled time of your session:  Session Code: SP21DBSEINF001 Name: Radu Pârvu Email: radu.parvu@accenture.com  Position: Director Twitter: https://twitter.com/rparvu Linkedin: https://www.linkedin.com/in/rparvu/ Bio: Radu has over 21 years of experience in various database projects (mainly Oracle but other DBMS, too).Radu holds License (one degree over Bachelor) of Engineering…

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