How to do PDB PITR in #Oracle 12c

A logical error happened in one Pluggable Database. A PDB Point-In-Time-Recovery rewinds it while the others remain available and stay as they are.

Logical error in PDB2

Logical error in PDB2

The blue arrow represents the Multitenant Database cdb1 with all its containers. A while back in the past, a logical error affected only pdb2. cdb1 is in Archive Log Mode and backups from before the logical error of at least the root container and pdb2 are available. What (more...)

Oracle Midlands : Event #17 – Summary

Having spent the last two weeks at Oracle OpenWorld 2016, what’s the obvious thing to do within a couple of days of getting back? Go to Oracle Midlands to hear more about Oracle 12c Release 2 of course!

First up was Dominic Giles with “Oracle Database 12c Release 2: Whats new?… What’s improved?” I’ve been a big fan of SwingBench forever so the name Dominic Giles has been familiar to me for a (more...)

Oracle Database 12c STIG Compliance Standard sample code is here!

One of the most requested features in the compliance management area has been a compliance standard for Oracle Database 12c. As most of you would know, Oracle Database 12c has been out for quite some time, and indeed Larry Ellison has just announced at OOW2016 availability of Oracle Database 12cR2 in Oracle’s public cloud offering. However, as I discussed in another post earlier this year, creating a new STIG compliance standard is not a simple (more...)

Oracle OpenWorld 2016 : It’s a Wrap!

That’s another Oracle OpenWorld (OOW) done, so it’s time to reflect on the event.

I think the most surprising thing for me was how much I enjoyed the User Experience (UX) and Internet of Things (IoT) stuff. I did the UX Strategy Day and the “Oracle Applications User Experience Cloud Exchange” afternoon and they were really fun and interesting. The IoT session took me back to my childhood, playing with wires and breadboards.

iot

For years the (more...)

“My Kingdom For A Histogram”


"Don't you know anything at all about numbers?"
"Well, I don't think they're very important," snapped Milo, too embarrassed to admit the truth.
"NOT IMPORTANT!" roared the Dodecahedron, turning red with fury.  "Could you have tea for two without the two, or three blind mice
without the three? Would there be four corners of the earth if there weren't a four? And how would you sail the seven seas without
a seven?"
 (more...)

PK Histogram

One of the little myths of Oracle appeared on the Oracle-L list server a few days ago – the one that says: “you don’t need a histogram on a single column unique/primary key”.

Not only can a histogram be helpful on a column that’s declared to hold unique values, the optimizer may even spot the need automatically. It’s a little unusual (and probably the result of poor programming practice) but it does happen. Here’s an (more...)

Comparing workloads across databases

Does this question sound familiar? “We are running the exact same workload in UAT as we do in production, but it behaves completely different. Can you help?”

If it does, then you might find the following post useful, provided you are appropriately licensed to use this feature anyway. I have been working on AWR data for a long time, and one of the best ways to do so according to David Kurtz and others, (more...)

Oracle Enterprise Manager Cloud Control: Write Powerful Scripts with EMCLI

Last week, I attended the Oracle Open World and did a presentation about writing scripts with EMCLI. If you’re not familiar with EMCLI, it’s the command line interface for Oracle Enterprise Manager Cloud Control. Here’s my presentation:

Although EMCLI is a very specific topic which appeals only to advanced users, a lot of people attended my session. I would like to thank Ray Smith (IOUG Director (more...)

SQL Trace in Oracle Database Exadata Express Cloud Service

Today I started having a look to the Oracle Database Exadata Express Cloud Service announced last week at Oracle OpenWorld. Note that since the amount of resources provided (in summary, 1 OCPU, 20 or 50 GB of database storage) is very limited, in general, in my opinion that service will only be useful for functional tests. In fact, if it wasn’t because that is the very first 12.2 release (12.2.0.0.3 (more...)

Oracle OpenWorld 2016 : San Francisco to Birmingham

I did my usual thing of not sleeping well before an early flight. I’m so nervous about waking up late and missing the flight I can’t sleep properly, which sets me up for a terrible day of travelling…

I was awake before my 04:45 alarm, so I had a shower and messed about on the computer until it was time to leave. I was sharing a car with Gustavo and Alex, who both had (more...)

MobaXterm 9.3

MobaXterm version version 9.3 was released about a week ago. The eagle eyed amongst you may have noticed I didn’t post about 9.2. That’s because it was released the day before 9.3. 🙂

The downloads and changelog are in the usual places.

If you use Windows and ever need SSH or an X server, you need this in your life. Imagine Putty and Cygwin wrapped up together, placed on a exercise program and injected (more...)

Shirts of OpenWorld

OpenWorld just isn’t OpenWorld without enjoying a bit of fun with one’s attire Smile

 

Img_0023a      Img_0026a

Img_0021a      Img_0025a

Img_0022a      Img_0024a


Video Tutorial: XPLAN_ASH Active Session History – Part 12

The final part of the video tutorial explaining the XPLAN_ASH Active Session History functionality continuing the actual walk-through of the script output.


This is the final part of this tutorial, but there are more tutorials coming - about configuring the script, script internals and also the Rowsource Statistics mode of the script.

Datapump Does not Export Permissions on Objects Owned by SYS

I was reminded recently that Datapump does not export permissions on objects owned by SYS so I decided to write a post about it for my blog. It was tested on an Oracle 11.2.0.1 database. First I created a user called USER1:

SQL> conn / as sysdba
Connected.
SQL> create user user1
  2  identified by user1
  3  /

User created.

SQL> grant create session to user1
  2  /

(more...)

Oracle OpenWorld 2016 : Thursday – Day 4

And here we are. The last day of Oracle OpenWorld 2016…

The first session I went to was a panel session called “Thinking Clearly About Database Application Architecture” with Gerald Venzl, Bryn Llewellyn, Connor McDonald, Toon Koppelaars, Cary Millsap. The session started with an introduction by Toon, explaining how the thick database architecture model is provably superior to the thin database model, especially from a performance perspective. I am definintely in (more...)

NetFlix – Blockbuster Movies

I mean, in principle it’s not that special, being that the info is already on…

Oracle 12.2 Cool New Features

As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool version, the downside is that is currently available on Oracle cloud only. We are all waiting for the on-premise release so we can install and … Continue reading Oracle 12.2 Cool New Features

Oak Table World 2016 Followup

The Oak Table network is a closed membership of about 100 technical scientists who have a passion for technology and the world around them.  These men and women, representing some of the brightest minds from each of their companies, are individuals who have built companies and major technical innovations.

Initially, much of their research and work was presented at Oracle Open World.  Over time, Oracle Open World welcomed (more...)

Oracle Midlands : Event #17

Don’t forget Oracle Midlands Event #17 next week!

om17

I don’t know about you, but I would like to know what Oracle have been up to. There has been very little in the way of publicity from them recently… 🙂

If you live near, please show your support for the event and come along. It’s free thanks to the sponsorship by RedStackTech.

Cheers

Tim…


Oracle Midlands : Event #17 was first posted on September 22, 2016 at 7:41 am.
©2012 (more...)

Oracle OpenWorld 2016 : Wednesday – Day 3

I started the day by meeting up with a bunch of people at the Dbvisit breakfast. This has become a regular event over the last few years. Followers of the blog know I like the Dbvisit folks and they tend to attract people I find fun and interesting. After food, loads of coffee and interesting conversation, it was time to head across to the conference.

I bumped into Liron and Zohar at the OTN lounge and walked over with them to watch Connor (more...)