dba – Page 3 – Learning is not a spectator sport

New LINESIZE settings for SQLPlus

Anyone that has used SQL Plus since its inception will be familiar with this frustration: There is my window, with

When the scheduler came into existence in Oracle 10g, there was a cool API call that could be used to

A quick tip just in time for Christmas I logged on to my database this morning, and things just didn’t

If you take a look at the log files created by the listener, there is obviously a nice wealth of

Cloning a pluggable database takes time, and for environments where you’d like to use clones as part of unit testing,

In the recent versions of the Oracle database, we’ve had the ability to convert between a System Change Number (SCN)

I had a friend point this one out to me recently. They use DBMS_JOB to allow some “fire and forget”

Direct mode insert using the APPEND hint is a cool piece of technology that lets you load bulk data into

Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition

I posted a video a couple of days ago showing a trigger mechanism to customize the capture of DDL that