Estimate Defragmentaton Benefits for a Bigfile Tablespace

Database: Oracle Database 19c Enterprise Edition Release – Production Version 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: […]

Read more "Estimate Defragmentaton Benefits for a Bigfile Tablespace"

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. Using SQL Developer in a foreign, non-English language was […]

Read more "Starting Oracle SQL Developer with Custom Parameters"

Oracle Autonomous Transaction Processing: Client Setup

a. First step is the database creation. Quite straightforward: b. Next step is to a connection setup connection from local client: from the main datbase page we click the DB Connection button and download the client credentials: A zip archive will de downloaded into your local client machine. In my case, the file is called: […]

Read more "Oracle Autonomous Transaction Processing: Client Setup"

Oracle Instant Client for macOS (Intel x86)

Oracle does not release anymore full client packages for the Mac clients. Therefore, we need to use the Instant Client from: The installation is quite simple but we need to rememeber that, in order to have a functional client for a DBA we would need to download three packages at least: Basic Package – […]

Read more "Oracle Instant Client for macOS (Intel x86)"

Disable Mac OS X Gatekeeper

Ocassionally, there is a need to install an app created by a developer that is not identified by the security policy in place on the Firm’s MacBook. Here is the short procedure I identified it works for me: in terminal type: sudo spctl –master-disable verify with: spctl –status open the application and quit it in terminal, type: sudo […]

Read more "Disable Mac OS X Gatekeeper"