Oracle

I use SQLcl a lot and install it on every environment I work on. It’s fully compatible with SQL*Plus and has useful extensions to interact with OCI, Autonomous Databases and Data Pump. My SQLcl configuration file is named ’login.sql’ and located in the ‘~/work’ directory. I also keep my ’tnsnames.ora’ file here. The location of these two Oracle configuration files is configured in ‘~/.bashrc’. # Oracle TNS location export TNS_ADMIN=$HOME/work # SQLCL login file export SQLPATH=$HOME/work This is my SQLcl configuration file. ...

Occasionally I find myself migrating Oracle databases between environments using Data Pump. Enterprise applications tend to use multiple tablespaces for logical separation (and historical reasons). However, this isn’t possible when the target database is Autonomous Database (ADB) hosted on Oracle Cloud Infrastructure (OCI). ADB is a managed service so DBA’s can’t create tablespaces and are limited to ‘DATA’. However, Oracle 19c Data Pump supports wildcards for the REMAP_TABLESPACE parameter which allows multiple tablespaces from the existing application to be mapped to the ADB DATA tablespace. ...

Connor McDonald posts an excellent series of articles about tuning a database application. This analysis from a end user perspective reminded me of my own experiences when I was a technical consultant helping customers running a large CRM application, typically in call centres scattered across Europe. I was often summoned onsite and told to solve the problem that ‘The application is slow’. Usually, different people were eager to give me their view on the issue:- ...

Jeff Moss' article about the commercial and free versions of Toad and the incredibly tenacious, persistent breed of salesperson bred by Quest Software got me thinking about the Oracle DBA tools I use. People SQL*Plus Statspack putty People are important because people have developed the application, people are using the application, people are managing the servers, people are managing the database and intelligent people have configured that very expensive storage array. ...