Search

Top 60 Oracle Blogs

Recent comments

November 2013

OakTable World UK 2013

Scale Abilities is proud to be sponsoring the first independent OakTable World UK event along with co-sponsors Pythian and Dbvisit. The event will be held on Monday 2nd and Tuesday 3rd December, hosted across the street from the Tech13 conference at: Premier Inn, 7-11 Lower Mosley Street, Manchester, Greater Manchester M2 3DW. Registration is required - […]

OakTable World UK 2013

Scale Abilities is proud to be sponsoring the first independent OakTable World UK event along with co-sponsors Pythian and Dbvisit. The event will be held on Monday 2nd and Tuesday 3rd December, hosted across the street from the Tech13 conference at: Premier Inn, 7-11 Lower Mosley Street, Manchester, Greater Manchester M2 3DW. Registration is required - […]

Theory of Constraints: the DBA

9627525993_af43154455_z

photo Celestine Chua

“Do you think the great Skeeve has nothing to do with his time but guard your borders? Do you want to tie up your high-cost magician doing the job a low-cost soldier could do?” – Aahz, MYTH Conceptions by Robert Asprin

Database Upgrade – What’s the Bottleneck?

I met with a customer today who described for me the challenges they had in their previous 10g to 11g Oracle database upgrade. Their requirements boiled down to this:
• The business can’t afford a lengthy cutover time for the upgrade.
• The business can’t afford any data loss.
• They business had to be able to rollback the upgrade in the event of a fail.
• The 8-10 downstream systems need to be upgraded very quickly soon after.

OSP #2a: Build a Standard Platform from the Bottom-Up

This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

OSP #2a: Build a Standard Platform from the Bottom-Up

This is the fourth of twelve articles in a series called Operationally Scalable Practices. The first article gives an introduction and the second article contains a general overview. In short, this series suggests a comprehensive and cogent blueprint to best position organizations and DBAs for growth.

MOUS 2013 Presentations

Just a quick note/announcement, that we had our annual Michigan Oracle Users Summit yesterday at the VisTaTech Center on the campus of Schoolcraft College, in Livonia, MI.  It was a good conference, and I think everyone who made it out, enjoyed their time there and saw some excellent presentations.

I did two presentations, Understanding and Interpreting Deadlocks and All About Indexes.  The presentations will be available at the MOUS website, but I also wanted to make them available here.  (See the links above.)

P.S.  I finally, just today, got my storage for my GoldenGate test boxes, so, I’ll be proceeding with that testing soon.  Stay tuned for my next blog post in that series, in a week or so.

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 […]