view counter

Feed items

11.2.0.4 new features and a OPTIMIZER_DYNAMIC_SAMPLING change

As of 27th August  2013, 11.2.0.4, the final release of 11GR2 was made available – a new features document is available . I will give a quick bullet list of the new features and then discuss one very important one that is not mentioned.

UKOUG – Tech13 – day 3 review

Another busy day at the Manchester Central complex. An early start with Martin Nash talking about RAC connectivity issues and bugettes. Very interesting but I don’t think my brain was fully in gear at 08:30 after a big hotel breakfast.

Straight into another two-man CERN presentation on Lost Writes. The first half was  about a scenario they had seen where an index has lost some data and frankly there was no explanation for what caused it to happen. However the second part was around how you might deal with the scenario and that was very good and gave a lot of food for thought.

UKOUG Tech13 – day 2 review

UKOUG conference day 2 opened up with Tom Kyte talking about 5 PL/SQL things you probably didn’t know. It did have 12c in the title but I think 4 out of the 5 were pre 12C. Implicit conversions are EVIL is my main take-away and he made me aware of the power of the PL/SQL warning framework to highlight any implicit conversions and other no-nos. Another important warning was when you code a WHEN OTHERS statement but do not follow it with a RAISE statement. Overall, an interesting discussion which I enjoyed despite only having ever written about 200 lines of code in my whole life.

UKOUG Tech13 day 1 review

UKOUG conference day 1 and to my eye there does not seem to be that many differences between Manchester Central and Birmingham ICC.  Lots of smaller halls and a large main hall,  a similar lunch available, the same lack of seating. I understand that attendance is seen comparable as well. Overall I see it as a refreshing change which will suit some and not others.  Make or break is the quality of the drinks do later on – that will be reported on tomorrow.

Ready for UKOUG Tech13

I have downloaded the agenda app for UKOUG Tech 13 – Mon 2nd – Wed 4th December in  Manchester and I have selected the talks I want to attend.

Primarily they are from the database streams with a bit of Engineered systems (Exadata for me) thrown in. Undoubtedly the release of 12C has generated many of the talks and that is all very good – exactly what the conference is there for – to find out what is new and which new features work well or can be adopted easily with real benefit.

I have seen the future – cloud computing – but not just yet

Today I had the opportunity to see Amazon Web Services being used in a real environment and I was very impressed with what I saw. The ability to drive any configuration you want from a menu system and pay for only what you use seems to be the way that computing must go.

UKOUG featured speaker of the week – AWR presentation

I am speaking at the UK Oracle User Group  conference in Manchester on Weds 4th December on the subject of building and using an AWR repository but I also include the capture and long-term retention of OEM data as well.I have given this talk once already to a SIG and it got very good feedback and I have developed the ideas significantly since then.

I am also pleased to say that I have been selected as featured speaker of the week at the UKOUG site.  Caution – it does include my photograph.

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.

view counter