Search

Top 60 Oracle Blogs

Recent comments

July 2013

Windows Blue (8.1) and Oracle Database 12c

Inspired by this article, I decided to download Windows Blue 8.1 and install it on VirtualBox. Once Classic Shell was installed it looked almost usable. :)

The Windows version of Oracle 12c is now available, so that seemed like the obvious thing to try next. That went really smoothly.

12c First N

There have been a couple of nice posts about the “Top N” (or First N / Next N)  syntax that has appeared in 12c, here and here, for example. I particularly like the first set of examples because they include some execution plans that give you a good idea of what’s  going on under the covers. “Under the covers” is important, because if you don’t actually have a large data set to test on you might not realise what impact a “Top N” query might have on a production data set.

Oracle 12c - incremental backup for DataGuard over network

If you have DataGuard or standby database in your organization you probably will love that new RMAN feature. Since 12c it is possible to catchup standby database using incremental backup using one command. Additional space and time need to run incremental backup, copy over to standby and restore can be limited to time required to run incremental backup over network.

See short example:

Stopping recovery on standby 

[oracle@ip-10-0-1-79 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 7 12:56:24 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

Oracle 12c - incremental backup for DataGuard over network

If you have DataGuard or standby database in your organization you probably will love that new RMAN feature. Since 12c it is possible to catchup standby database using incremental backup using one command. Additional space and time need to run incremental backup, copy over to standby and restore can be limited to time required to run incremental backup over network.

See short example:

Stopping recovery on standby 

[oracle@ip-10-0-1-79 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 7 12:56:24 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:

from a friend…

A friend was recently describing Agile to me…I stress, not Agile the principle, but Agile the way its been implemented at their site…I thought I’d share it with you :-)

[warning: profanity]

Oracle Database 12c Security Auditing

I started to ask a question a few blog posts ago about how does the 12cR1 database affect database security audits. I have decided to come back to it now as it is a good chance to do so. I....[Read More]

Posted by Pete On 08/07/13 At 05:31 PM

DBaaS: The Technology Behind Delphix

This post is part of the series on Delphix:


Delphix is made up of three main components:

Oracle Database 12c : Reality Check for Readers…

I shouldn’t really need to write this post, but recent events seem to indicate it is necessary…

Oracle Database 12c is new! The people out there writing articles can be broken down into three basic groups:

  1. Those people who have been using the beta product for over a year and really pushing it hard.
  2. Those people who have dabbled a little with the beta product, giving them enough knowledge to write some articles.
  3. Those people, like me, who got their first sniff of 12c when it was released a couple of weeks ago and are now on a steep learning curve.

Regardless of which group people belong to, we all got the final production release at about the same time. It is quite common for features to be pulled from the beta product and for minor API changes to take place, so even those on the beta program might have some re-learning to do.

So why write this post?

12c Partial Indexes For Partitioned Tables Part I (Ignoreland)

In my opinion, one of the unsung “Heroes” of the new 12c Oracle database are improvements associated with Partitioning. There are lots of really nice capabilities introduced in the 12c database that significantly improves the manageability of partitioned environments. One of those new capabilities is the ability to now create both local and (importantly) global […]