Top 60 Oracle Blogs

Recent comments

July 2015

JSON support in Exadata and later

Some time ago Oracle announced that RDBMS has built-in support for JSON processing. A little later it was also mentioned that you have support for JSON in the Exadata storage servers for offloading. This is probably a lot more exciting to users of JSON than it is to me as I’m not a developer. However, whenever an announcement such as the one I’m referring to is made I would like to see for myself how much of it is implemented in software. Like I said, I’m not a developer so apologies for a silly example: what I’m showing you here can probably done differently and is not the best use of an Exadata. But all I really wanted to test is if JSON support actually exists. I am using cellsrv and RDBMS for this test.


Become an #Oracle Certified Expert for Data Guard!

It is with great pride that I can announce a new certification being available – Oracle Database 12c: Data Guard Administration.

We wanted this for years and finally got it now, after having put much effort and expertise into the development of the exam. It is presently in beta and offered with a discount. Come and get it!

Kostenlose Webinare zur neuen #Oracle Datenbankversion: #12cjetzt


Hochkarätige Referenten zum Thema Oracle Database 12c – Jetzt!

Wie und warum Sie jetzt auf 12c kommen sollten erläutern wir in sieben Webinaren von je einer Stunde Dauer. Die Webinare finden an jeweils verschiedenen Tagen statt, beginnend am 11. August, wo Mike Dietrich zum Thema Upgrade (natürlich) vortragen wird.

Einfach anmelden und bequem und kostenlos informieren – das ist doch ein unschlagbares Angebot, oder? Finde ich auch :-)

Delphix Express – a free version of Delphix


#555555;">#2970a6;" href="">2401421989_e05053cbf7_z


#555555; text-align: right;">photo by #212124;" title="Go to Yannis's photostream" href="" data-track="attributionNameClick" data-rapid_p="48">Yannis (CC 2.0)

CBO series

Update 9th July 2015:  part 4 now published.

I’ve changed the catalogue from a post to a page so that it gets a static address:

I’ll leave this posting here for a while, but will probably remember to remove it some time in the future.


Which piece of code will be faster (clue – the table in question has no indexes):

Option 1 – pure SQL

update join1 set
        data = data||'#'
where   key_1=500
and     key_2=23851
and     key_3=57012
and     key_4=521
and     key_6=1
and     key_7=23352

Option 2 – a silly PL/SQL row by row approach:

Why A Brand New Index Might Benefit From An Immediate Coalesce (One Slip)

A recent question on the OTN Forums Reg: Index – Gathering Statistics vs. Rebuild got me thinking on a scenario not unlike the one raised in the question where a newly populated index might immediately benefit from a coalesce. I’ve previously discussed some of the pertinent concepts such as how index rebuilds can make indexes bigger, not smaller […]

New Conference Speaking Dates Added

In the last few years I have not done as many conference speaking dates as I used to. This is simply because when offered they usually clashed with pre-booked work. I spoke for the UKOUG in Dublin last year and....[Read More]

Posted by Pete On 06/07/15 At 09:40 AM

Transport Tablespace using RMAN Backupsets in #Oracle 12c

Using backupsets for Transportable Tablespaces reduces the volume of data you need to ship to the destination database. See how that works:

RMAN TTS on the source database

RMAN TTS on the source database

The tablespace is made READ ONLY before the new BACKUP FOR TRANSPORT command is done. At this point, you can also convert the platform and the endian format if required. Then on the destination site:

Upgrade Cloud Control 12cR4 to 12cR5

em-12cA couple of weeks ago I wrote a post about doing a Cloud Control 12cR5 installation and said I would be testing the upgrade from 12cR4. I’ve now done that.