Oracle VM Consulting
view counter

Feed items

Recover table from RMAN in 12c

When  I read the list of 12c new features the one that interested me immediately was the ability to be able to recover a table from an RMAN backup. This seemed to be quite challenging as RMAN is an image copy of blocks and a table is normally copied using a logical Datapump export.

What Oracle have delivered is a packaged technique which recovers only the necessary tables so as to get the data dictionary and any undo/redo segments necessary to get all the data back to a  specific point in time whether that be a SCN or a timestamp.

The 10 commandments of being a good DBA manager

With a subtitle of ‘The 10 commandments of being a good DBA within a DBA team”

I have been considering for a while what might make a good DBA manager and how that has a knock-on effect of developing DBAs and giving them an insight into best practises. These are some of my thoughts. I am not pretending to be a good manager, but I do try my best and these are some of the methods which I think have merit.

Large CLOBs and attention to detail needed while reading Oracle Support notes.

This post was forwarded to me by Vitaly Kaminsky who did work with me but has now bettered himself elsewhere. He writes :-

I have recently been involved with performance tuning of a database layer for the major Dutch website which was preparing for the “crazy days” of sales on the 2nd to 5th of October.

The general setup was as follows:
2-node physical RAC cluster with fast storage layer running ORACLE 11gR2 SE and ASM.

expdp to ASM and exclude table syntax – two workarounds

A short entry showing two problems that I have come across recently with datapump export and the  workarounds I used.

Using ASM disk for exports

SQL Plan Management – how to really utilize and not just implement

The title of this post is intentionally slightly unclear and hopefully it is intrigued people to view the post and even better, add their comments.

SQL Plan Management has been around since 11G came out which is back in 2007. It does not require a tuning pack, so the package DBMS_SPM can be used without additional licensing but if the SQL Tuning advisor is used to generate new profiles via tuning task then that does require a tuning pack license.

UKOUG Conference here I come

I am pleased to say that I have been offered at a slot at the UKOUG Tech conference to present my paper on “The design, creation and maintenance of an AWR repository”. I have presented this once already to a SIG meeting and I felt it went down well and the feedback and comments I received afterwards supported that and allowed me to develop the ideas further.

Using EM12C to see bind variables

I have had these images for a few weeks but I was reminded to make a post after seeing Doug Burns present on using the monitoring tool in 12c at a UKOUG SIG meeting last week and he mentioned how you can see bind variables quite easily. Of course you could always work your way through a 10046 trace but I think you might find these options easier.

Firstly how to get them from the command line

select sql_id, sid from v$sql_monitor where sql_exec_id = 16779111;


————- ———-

6jcg0bbfm9z6p 1122

Building an AWR repository – UKOUG SIG presentation

I am pleased to be presenting at the UKOUG AIM and Database SIG  in London on Thursday 18th July. I am talking about building and using an AWR repository.

UKOUG Database SIG Leeds- review

Last week we held the UKOUG Database SIG in Leeds as I described in a recent post. It was a well attended event in a  central location with excellent refreshments available. – Thank you to UKOUG’s  Anna Crellin for organising the day so well.

UKOUG Database Server SIG – Leeds May 9th

This is just a reminder for what I think is a strong Core DBA centric agenda being organised by the UKOUG

The location is the Met Hotel in Leeds, right by the station and the last meeting in Leeds several years ago, was well attended so I am sure this one will be as well.

The agenda is below


UKOUG Database Server SIG Meeting

Date: Thursday 9th May 2013

Time: 09:00 – 17:00

Location: Leeds/ West Yorkshire

Venue: The Met, Leeds

view counter