Radu Pârvu’s Blog

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 ADB’s, the instructions provided by Oracle will be usable only if we keep changing the local TNS_ADMIN environment variable! That would not be possible for some of my Clients that have single TNS_ADMIN location and content that is managed at entreprise level!

Continue reading “SQL*Plus Client connections to several Oracle Autonomous (Always-Free)”

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.

Continue reading “Estimate Defragmentaton Benefits for a Bigfile Tablespace”

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 will discuss all the perspectives of database security: OS Security Model Data at rest encryption Network encryption Authentication PDB Isolation Model Patching And we will cover the ATP Dedicated Security aspects

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.

Continue reading “Is Oracle Autonomous Database the answer to the many database security issues? (I)”