Category Archives: Oracle

ANSI expansion

-+*Here’s a quirky little bug that appeared on the OTN database forum in the last 24 hours which (in 12c, at least) produces an issue which I can best demonstrate with the following cut-n-paste:

SQL> desc purple
Name …

ASH

-+*There was a little conversation on Oracle-L about ASH (active session history) recently which I thought worth highlighting – partly because it raised a detail that I had got wrong until Tim Gorman corrected me a few years ago.
Once every second…

To patch or not to patch?

-+*Mary Ann Davidson wrote a great piece on her security blog today, which basically talked about focusing on the important vulnerabilities, not necessarily the ones that get the most press. Added to that, the risk associated with a vulnerability may we…

12c MView refresh

-+*Some time ago I wrote a blog note describing a hack for refreshing a large materialized view with minimum overhead by taking advantage of a single-partition partitioned table. This note describes how Oracle 12c now gives you an official way of doing s…

UKOUG System Event : I’ve got a paper selected.

-+*I’ve just found out I’ve got a paper selected for the UKOUG System Event on May 20th. Check out my badge.

I was a spectator at last year’s event. At first glance you might think much of the content is not directly related to my job…

Oracle Linux 7.1 Preinstall Packages available for 11gR2 and 12cR1

-+*Every so often I have a nose around the contents of the Oracle Linux public yum repositories and guess what I found in the OL7.1 base and OL7 latest repositories.

oracle-rdbms-server-11gR2-preinstall-1.0-3.el7.src.rpm
oracle-rdbms-server-11gR2-preinst…

Is Your Shellshocked Poodle Freaked Over Heartbleed?

-+*

Security weenies will understand that the above title is not as nonsensical as it appears. Would that it were mere nonsense. Instead, I suspect more than a few will read the title and their heads will throb, either because the readers hit themselv…

Oracle Exadata Performance: Latest Improvements and Less Known Features

-+*Here are the slides of a presentation I did at the IOUG Virtual Exadata conference in February. I’m explaining the basics of some new Oracle 12c things related to Exadata, plus current latest cellsrv improvements like Columnar Flash Cache and I…

Birmingham City University (BCU) Talk #2

-+*As mentioned in a previous post, when I was at Birmingham City University (BCU) speaking at the UKOUG Next Gen event, one of the lecturers saw me and subsequently asked if I would come in and do some technical talks for the students. I did the first ab…

The Four Ps of Standards/Procurement Requirements/”Whatevahs”

-+*

I am a veteran – not merely a military veteran, but an information security veteran. I don’t get medals for the latter, but I do have battle scars. Many of the scars are relatively recent: a result of tearing my hair out from many, many, many …