UKOUG 2008 – Wednesday

HA Roundtable

Oracle’s Stephan Haisley was asking if you could have any changes implemented in the Oracle HA sphere would they be?

I was thinking I would like physical standby to be able to operate across versions so you could upgrade your standby to say 12 while your primary is 11 sync it back up and switchover – giving you a very quick (and easy) way of upgrading database versions.

Not many people using the Observer.

Some chat about licensing Oracle when using clusterware to failover a single node instance. You don’t need a RAC license just to use clusterware or indeed run clustered ASM.

Moans Norgaard – Shock Upgrades

Very funny talk.

“All developers have left earth and gone into the cloud where they will reinvent the things that the database can do already”

Talking about a customer who implemented 4-node windows RAC had major problems, mentioning 9 months of pain and the customer is moving to 1 node RAC!?!

The danish experiment involoves using the diagnostic & tuning pack with Real Applications Testing.

Idea is to capture workload and replay it into the 11g upgraded production copy.

back to the real world:

Upgrades are hell!

10g EM did not work for capture – but PL/SQL did

11g PL/SQL only gives XML reports!?!

nice and useful replay reports.

With these caveats RAT seems to work.

Moans stating that the upgrade does not work, but now talking about going 9i  ->

Not clear yet why a  -> 11g upgrade did not work. Saying upgrades/patches have become worse, not really seeing that between 10g versions.

So a real shock upgrade is going -> 11g

Saying no one wants to upgrade to 11g

Oracle Performance Management – Gaja Vaidyanatha

Performance tuning methodology

Trap: though normally true, the most expensive step from an elapsed time point of view is not always the step with the most rows processed.

service time = f(hardware specs, laws of physics)

wait time = f(wasteful processing, resource contention)

8 real world case studies

case study 0 shows 15 logon per seconds – mw not using connection pooling.

More case studies, perhaps the most interesting at the end which was a Solaris 10 problem and one which the standard performance methodology could not help with , needed to look at O/S.

This talk was at least 1.5 hours, and I just felt it was maybe just a bit too long!

Dataguard 11g New Features – Michael Moller

This was meant to have been delivered by Carl Jan Engel but he could not make it.

This was a run through of some of the more interesting new features with good observations on what new features were useful, and which were pretty pointless. I found it particularly amusing when he used the term the broken rather than the broker.

Michael’s demos went AWOL, but I don’t think it harmed things too much.

It’s a shame that most of the good stuff is a paid option, including active dataguard.

The evening was the 25th Anniversary party with the night being rounded of far too late in the tap & spile


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s