Search

OakieTags

Who's online

There are currently 0 users and 28 guests online.

Recent comments

Affiliations

Uncategorized

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

Virtual Columns

This is just a temporary note to let people know I’ve added an update to my Virtual Stats article, highlighting a possible performance threat when you gather stats.

I’ll be deleting this note in a couple of days, so I’ve disabled comments and pingbacks

 

 

Database as a Service

Concept of Hand with Electronic Fingerprints

by Chris Fuller and Kyle Hailey

To improve infrastructure and DBMS software utilization, and to drive greater IT operational productivity, companies are implementing internal DaaS capabilities to address their database needs.

Screen Shot 2014-01-15 at 11.17.58 AM