Search

OakieTags

Who's online

There are currently 0 users and 44 guests online.

Recent comments

Affiliations

Uncategorized

Lineage of the 100-400 slide PPT

 

5727330912_ca5a5a7760graphic by Frits Ahlefeldt-Laurvig

There is the  Mandel approach to power points in presentations where one is suppose to spend 3 minutes per slide, thus a 60 minute presentation is 20 slides or less.

How about going the other way, showing 3 or more slides per minute?

RMOUG Training Days 2014

I made my way again this year to one of the best, if not the best, user group conferences, the Rocky Mountain Oracle User Group Training Days, held in Denver Colorado on the 6th and 7th of February. Huge kudos to Kellyn Pot’Vin and the rest of the organizing team (see her review here) for […]

Full free day of performance class at Oracle Corp

This Thursday, Feb 20, I will be giving a full day of free Oracle performance classes.  Remember the serve the best lunch ever at the Oracle conference center . It’s top class!

Register here

Here is the write-up from NoCOUG on the day:

11.2.0.4 Upgrade

A warning on Oracle-L from Chris Dunscombe: If you’ve got a large stats history – with lots of histogram data – then the upgrade could take an unexpectedly long time. Presumably the same is true if you upgrade from 11.2.0.3 (or earlier) to 12c.

 

RMOUG

My provisional agenda for Training Days 2014

Wednesday:
3:15 I present “Selectivity and how Oracle calculates it”

Thursday:
8:30 – 9:30 (Difficult choice) Iordan Iotzov – How sure is the optimizer about its cardinality estimates
11:15 – 12:15 (Difficult choice) Andy Colvin – Common Exadata mistakes
13:15 – 14:15 Jeff Smith – Oracle Careers panel discussion
14:30 – 15:30 I present “The revolution in histograms”.
16:00 – 17:00 Terry Sutton – “Now what’s up with dbms_stats”

Friday:
8:30 – 9:30 Alex Fatkulin – Why you may not need offloading
9:45 – 10:45 Jeff Jacobs – SQL Performance anti-patterns
11:15 – 12:15 Alex Gorbachev – Hadoop for Oracle Database Professional
13:30 – 14:30 Bjoern Rost – The ins and outs of Flashback Data Archives

Then it’s off to the airport before the show is over to get my flight home.

Delphix success and Paternity Leave

73557821_e1b210395c

photo by Steve Jurvetson

I’m off on for a couple weeks for paternity leave! Actually started on Saturday night a week ago with the beautiful, stressful, exciting, fast birth of our second son. What a gift. :)

Fedora 20 : Upgrade from Fedora 19

It’s a little over a month since Fedora 20 was released, but during a terrible bout of insomnia last night I decided to upgrade my desktop PC.

The upgrades using “fedup” worked fine for the previous releases (Fedora 18, Fedora 19). Unfortunately, it failed abysmally for the upgrade to Fedora 20. I tried a few times, but I was not able to troubleshoot it, so I gave up and did a reinstall.

I’ve got an SSD for the system drive, but keep almost everything of importance on a second drive (and a backup drive). I tend to do most things in VMs, so I ended up doing the following:

Free developer day in Perth

Got a massive day of goodies coming to anyone in Perth..for absolutely no cost – just your time and your enthusiasm.

There’s something for

  • database developers
  • Apex developers
  • ADF developers

See you all there …

http://bit.ly/oddperth20140218

ORA-65131 grrrr

So…the future is container databases ?

Cool ! I’ll create all my databases as container databases….I’m so happy….until

SQL> CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH;
CREATE FLASHBACK ARCHIVE longterm TABLESPACE demo RETENTION 1 MONTH
*
ERROR at line 1:
ORA-65131: The feature Flashback Data Archive  is not supported in a pluggable database.

It is documented but seriously….that’s not so flash :-)

Man…I really really like this :-)

Yeah yeah, you can argue with me about backward compatibility, but I’m so glad someone snuck this into 12c…

11.2

SQL> grant resource, connect to demo identified by demo;

Grant succeeded.

SQL> select privilege
  2  from   dba_sys_privs
  3  where  grantee = 'DEMO';

PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACE

12.1

SQL> grant resource, connect to demo identified by demo;

Grant succeeded.

SQL> select privilege
  2  from   dba_sys_privs
  3  where  grantee = 'DEMO';

no rows selected