Uncategorized – Page 2 – Learning is not a spectator sport

DBMS_METADATA for INDEXES

Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get

Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve

Recently I cloned one my (pluggable) databases to a throwaway copy so that I could do some testing of an

Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our

INITRANS defines how many concurrent transactions you can have within a single datablock for a segment (table, materialized view, etc).

For pretty much as long as I can remember, the view V$SESSION_LONGOPS has existed. It has a suite of columns

So I tweeted this out on Friday and this reflects one of my joys with working with Oracle technology. The