SQLcl: Customizing on a Mac

In this post I will summarize the steps I've taken to customize SQLcl on my Mac working environment. We assume that the reader is familiar with the procedures outline din my previous post on SQLcl on setting up SQLcl on…

SQLcl: Setup on a Mac

Simple and straightforward steps about how to setup Oracle's new SQL command line tool on a macOS X environment. Download Download the mac kit from the Oracle site. Unzip the kit into the correct directory: % unzip Downloads/sqlcl-23.1.0.089.0929.zip -d Applications…

BUG? Oracle SQL Developer cannot access files on mac OS X

I used Oracle SQL Developer for years until recently (possibly after the upgrade to macOS 12.6.5?) when the SQL Developer stopped being able to access the files stored locally: Oracle SQL Developer Error The software does not prompt for access…

Linux Playground on #OCI

Spring is here and I will definitely spend more time outside on my bike and carrying my iPad in my backpack. So I was looking for an easy to setup environment to practice and train my shell scripting skills. And…

Problematic Statistics of the Application Objects in your Oracle Database

One of the often asked questions is to find out the status of the statistics of the application owned schemas. In this article, I will list the SQL code that I used for this purpose. As well, I will publish…

Oracle Automated DB Maintenance Tasks

This is a short article on how to manage the automated Oracle database maintenance tasks. Make sure the needed rights are in place by running the check: SELECT grantee, privilegeFROM dba_tab_privsWHERE owner = 'SYS'AND table_name = 'DBMS_AUTO_TASK_ADMIN'AND privilege = 'EXECUTE';…

%d bloggers like this: