The spinning beachball, a juddery interface, and fans running full pelt: what’s CPU doing in Activity Monitor, and what should you do about it?What to do when a process uses too much CPU
Tag: recipe
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…
Rețeta zilei
Rețeta zilei de 2 Aprilie 1940. Pofta buna!
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…
Read More Problematic Statistics of the Application Objects in your Oracle Database
Comparing Oracle Databases: Initialization Parameters
A method for comparing the Oracle init parameters of several PDB’s
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 work on an great autonomous TP instance and it is…
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…
Read More Starting Oracle SQL Developer with Custom Parameters
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. First step is…
How to monitor SQL with Oracle SQL Developer
The easiest way to monitor the SQL's currently executing
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…
Read More SQL*Plus Client connections to several Oracle Autonomous (Always-Free)
It is now possible to clone a database in Autonomous Cloud
Database cloning, very handy feature, is now available for Oracle’s Autonomous Cloud. Quite easy to implement, too: The options are:
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: https://www.oracle.com/technetwork/topics/intel-macsoft-096467.html The installation is quite simple but we need to rememeber that, in order to have a functional client…