Search

OakieTags

Who's online

There are currently 0 users and 32 guests online.

Recent comments

Oracle

Distributed Trap

Here’s an interesting (and potentially very useful) observation from an OTN database forum thread that appeared at the end of last week. It concerns the problems of pulling data from remote systems, and I’ll start by building some data:

Yes, Storage Arrays Can Deduplicate Oracle Database. Here Is Exactly Why It Doesn’t Matter!

I recently had some cycles on a freshly installed Dell EMC XtremIO Storage Array. I took this opportunity to prepare a blog entry about the never-ending topic of whether or not storage arrays are able to reduce physical data capacity through deduplication of blocks in Oracle Database.

Of Course There Is Duplicate Data In Oracle Datafiles

Before I continue, let me say something that may come as a surprise to you. Yes, Oracle Database has duplicate blocks in tablespaces! Yes, modern storage arrays can achieve astonishing data reduction rates through deduplication–even when the only data in the array is Oracle Database (whether ASM or file systems)!

Oracle 12cR2: Database parameters

For those in a desperate need to learn all 4841 database parameter variations of the…

Oracle 12.2.0.1 DBaaS database available

Just created my first Extreme Performance 12.2.0.1 database in the cloud.oracle.com. So just after a…

Oracle 12.2.0.1 Manuals available now!

Have a look what’s new and cool in the full Oracle 12.2.0.1 manuals / documentation…

Reorg

A current question on the OTN database forum asks: “What’s the difference between object and tablespace reorganization?” Here’s an analogy to address the question.

I have three crates of Guiness in the boot (trunk) of my car, one crate has 4 bottles left, one has 7 bottles left and one has 2 bottles. I also have two cases of Louis Roederer Brut NV champagne, one case has 2 bottles left and one has only one. (I have two objects in my tablespace – one of type Beer, one of type Champagne – and my boot requires manual free space management .)

I move all the Guiness bottles into a single crate and all the champagne bottles into a single case. That’s a couple of “shrink space compact” calls – I’ve re-organised the objects to get all the bottles in each object close to each other, but the crates are still taking up space in the boot.

Filter Subquery

There’s a current thread on the OTN database forum showing an execution plan with a slightly unusual feature. It looks like this:

Scoop – First glance of the new Oracle Live SQL?

When I was at OOW this year I saw the new (?) Oracle Live SQL…

How you should or shouldn’t design, program for, a performing database environment

My good friend Toon Koppelaars created a cool and very interesting, learning video about how…

I am now an ex-ACE Director

How apt that this should be my next blog post, following So long, and thanks for all the fish. I’ve been an Oracle ACE Director since 2009, and watched the program evolve in form considerably over that time. It’s always difficult to maintain high quality advocacy as a program grows – my time as part of the OakTable ‘junta’ … Continue reading "I am now an ex-ACE Director"