Search

Top 60 Oracle Blogs

Recent comments

November 2013

32K Columns

Oracle 12c has increased the maximum length of character-based columns to 32K bytes – don’t get too excited, they’re stored out of lines (so similar in cost to LOBs) and need some modification to the parameter file and data dictionary (starting the database in upgrade mode) before you can use them.

Richard Foote has a pair of articles on indexing such columns:

Data Management from a Theory of Constraints Perspective

1098176_10202046154420479_2047307696_n

When I read Eliyahu Goldratt’s the Goal in Grad School, one of the key things that stuck with me is that there’s always a bottleneck and that the process only moves as fast as the bottleneck allows it to move. The Theory of Constraints methodology posits three key measures for an organization: Throughput, Inventory, and Operational Expense. Sitting down to think about this, I reasoned that we could use those same metrics to measure the total cost of data for copies, clones and backups.

12c Indexing Extended Data Types Part II (15 Steps)

Finally, at long long last, I have a spare 30 minutes in my life to complete this blog entry !! As discussed previously, Oracle has extended the maximum length of varchar2, nvarchar and raw columns to 32K, but this comes with some challenges when it comes to indexing such columns due to restrictions on the […]

OTWUK13 (Battle For Britain)

I’ve been fortunate to attend and present at many Oracle conferences over the years but the one I would love to get to one year is the UKOUG conference. It always seems to have a great line-up of speakers and I’ve heard lots of positive feedback. Unfortunately, it’s a long long way from home, but […]

Theory of Constraints

phoenixproject-680x400

Great interview with Gene Kim, author of The Phoenix Project, discussing the Theory of Constraints and delays in project development. Here is an excerpt starting from minute 6:50

Untogether Lives

A little over a year ago, I wrote a review of a book called Girl 99 by Andrew P. Jones. I got an email from the author a few days ago to say his latest book, Untogether Lives, was released on Kindle, so I downloaded it straight away. Here’s what it’s all about.

Untogether Lives is a collection of fourteen stories that peek through the curtains of an eclectic cast, struggling to keep mind, body and the world around them together. From an amputee shoe thief, to an unlikely arsonist, to a sexually frustrated quadriplegic.

Predominantly dark and occasionally disturbing, these stories are not for the faint-hearted, but neither are they without humour. Not everyone in Untogether Lives gets a happy ending, and not everyone survives – but, hey, that’s life for you.

Oaktable World UK Dec 2 & 3

Oaktable World UK 2013

Oaktable World continues it’s global tour with the next stop in Manchester, UK during the UKOUG.

Scale Abilities is proud to be sponsoring the first independent OakTable World UK event along with co-sponsors Pythian and Dbvisit.

Check out the awesome lineup

otwuk

And it’s free. Just be sure to register to reserve your place.

 

Register at  http://www.scaleabilities.co.uk/oaktable-world-uk-2013/

Minimal-downtime PSUs on CRS with Cloned Golden Images

About a month or two ago, I was doing some work toward developing a process to patch CRS out-of-place using cloned golden images. I held off on publishing anything because I wanted to do some testing but we’ve been so busy with deployments and maintenance over the past month that I haven’t had a chance. I think that it might benefit a few people to go ahead and post the work I’ve done so far even though I’m not finished. Thus… note that this material is still very much in-process.

Minimal-downtime PSUs on CRS with Cloned Golden Images

About a month or two ago, I was doing some work toward developing a process to patch CRS out-of-place using cloned golden images. I held off on publishing anything because I wanted to do some testing but we’ve been so busy with deployments and maintenance over the past month that I haven’t had a chance. I think that it might benefit a few people to go ahead and post the work I’ve done so far even though I’m not finished. Thus… note that this material is still very much in-process.

Applying PSU 12.1.0.1.1 in the lab environment

Since the first patch for Oracle 12c has been made available I was of course keen to see how to apply it. For a first test I opted to use my 3 node RAC cluster which is running on Oracle Linux 6.4 with UEK2. This post is not terribly well-polished, it’s more of a log of what I did…

The cluster makes use of some of the new 12c RAC features such as Flex ASM but it is not a Flex Cluster:

[oracle@rac12node3 ~]$ srvctl config asm
ASM home: /u01/app/12.1.0.1/grid
Password file: +OCR/orapwASM
ASM listener: LISTENER
ASM instance count: 2
Cluster ASM listener: ASMNET1LSNR_ASM
[oracle@rac12node3 ~]$

My database is a standard 3 node administrator managed build: