Search

Top 60 Oracle Blogs

Recent comments

humour

Quantum Space

Here’s a not very serious note that makes a serious point.  I’ve got a small tablespace made up of 4 files, and here’s a little report I can run against the data dictionary for that tablespace:


select 'File space' What, nvl(sum(user_bytes)/1048576,0) MB from dba_data_files where tablespace_name = 'LOB_TEST'
union all
select 'Free space',      nvl(sum(bytes/1048576),0)         from dba_free_space where tablespace_name = 'LOB_TEST'
union all
select 'Extents',         nvl(sum(bytes/1048576),0)         from dba_extents    where tablespace_name = 'LOB_TEST'
union all
select 'Segments',        nvl(sum(bytes/1048576),0)         from dba_segments   where tablespace_name = 'LOB_TEST'
;

The name of the tablespace isn’t significant – it happens to be a tablespace I created to do some tests relating to space allocation with securefile LOBs, and it’s been hanging around ever since.

Friday Philosophy – How I Took The Step Up from Thought Leader to Paradigm Architect.

I’m sure you have come across the term “Thought Leader” before. You probably first came across it recently, in the last couple of years, and it is growing in occurrence. I’m always impressed by someone who describes themselves as a Thought Leader, I think it tells you a lot about the qualities of the person (*). At times I feel that I am also a Thought Leader – However, I recently decided to set myself the higher ambition of expanding my vision and becoming a Paradigm Architect. And I think I can tell you how you can do the same and also become a Paradigm Architect yourself.

Friday Philosophy – Genial Greetings & Festive Fun

For many of us, today will be the last working day before the Christmas Break (unless you live in one of the many places that don’t celebrate Christmas, in which case ignore this post). So Merry Christmas everyone and Happy New Year!

Friday Philosophy – Is a “Free Lunch” Only Ever a Mirage? Look Closer!

Nearly all of us have heard (or even used) the phrase “There is no such thing as a free lunch” and we know what it means – if something of value is provided for no up-front cost, you are paying for it in some other way. According to the Wikipedia entry for it the phrase could have originated from US bars that offered a free meal with a drink, but the meal was salty and so made you want to drink more. Now you know why some up-market bars offer free salty nibbles, it’s so they can sell you more beer and the extra profit is more than peanuts.

UKOUG Tech16 Day 0 – Car and Curry Chaos!

This year I decided to come to Birmingham a little early for UKOUG Tech16, coming up on the Saturday. I drove up to Lichfield where I grew up (15 miles North of Brum – which explains the touch of Brummie in my accent) in the morning to see my mum. Once we had discussed her various ailments and prejudices for a few hours and I’d unblocked her vacuum cleaner I set off into Birmingham to get to Jury’s hotel for 18:00. I was sure the shoppers would be pouring out of the city centre by then and it would be quietening down.

Friday Philosophy – Hello….?Dave?

In 2 days time the UKOUG Tech16 conference starts. I love this conference, I’ve been to all but 1 one of them in the last 15 years – but I am not going to go on about why I like it so much again.

Friday Philosophy – 3rd Normal Form, 3rd Normal People

I was at a wedding a few months ago and one of the guests was wearing a pair of bear ears (I think – they might have been raccoon ears, they were not exactly anatomically correct). What made it a little unusual was that the guest was an adult and something like 2 meters tall (6’4″ in real units). So they were rather noticeable. But that was it. No tail, no strange mannerisms, just being there and chatting to people, wearing ears.

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.

Nice Social Media Profile Picture! Oh… Err…

A few (months/weeks/days/hours)* ago I saw a friend request on Facebook. I looked at their profile which indicated that they were kind-of in my technical arena and the profile picture made me think “Wow – that’s an attractive person!” and I was about to click on the accept button.

And stopped.

I only friend people on Facebook who I know. By that I mean I have either met in real life and liked or have had a LOT of contact with through social media and liked. People who, if they were delayed at Stansted airport at midnight and needed a place to sleep, I’d be happy to go pick them up and bring them home to stay in my spare room.

Friday Philosophy: Be A Hero – OR Be The Best

There is a crisis! The database is not responding, the apps can’t work and the business is suffering. Management are doing what management are there for – panicking and demanding “Someone Do Something!!!”.

Step forward a DBA who logs into the server, checks the alert logs, spots what is wrong and fixes it. The database starts processing requests, the applications are all working fine and the business is back on track. What a hero!