Radu Pârvu

Notes on tech, tools, and thinking

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

    Manage Sessions in Oracle Database

    tech

    • 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

    • FreeBSD Development | FreeBSD Foundation

      Table of Contents (now with article PDFs) FreeBSD Code Review with git-arc How to Implement Simple USB Driver for FreeBSD Kernel Development Recipes Foundation Letter We Get Letters Practical Ports Events Calendar Click here to start reading. Download the full PDF here. — Read on freebsdfoundation.org/past-issues/freebsd-development/

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

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