Search

OakieTags

Who's online

There are currently 0 users and 50 guests online.

Recent comments

Affiliations

Uncategorized

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.

 

Oracle 12c Edition-Based Redefinition (EBR)

Oracle 12c has many great features for DBAs and Developers; I’ll be talking about more features 12c in future articles (watch this space).

Edition-Based Redefinition made its debut in Oracle 11g and provides an ability to significantly reduce downtime due to changes in PL/SQL and/or SQL. Oracle 12c removes some limitations present in 11gR2 implementation of EBR:

  • Materialized Views may use editioned resources
  • Virtual Columns may be used with editioned functions

Materialized Views are not-editionable; but, Oracle 12c allows them to depend upon editioned objects with a new clause and new syntax for ENABLE QUERY REWRITE. The EVALUATE USING clause indicates that a referenced object is editioned (editioned objects are invisible otherwise). ENABLE QUERY REWRITE may be limited to selected editions. The new Materialized View CREATE/ALTER syntax looks something like this:

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