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.
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.
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.
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.
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.
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
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.
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.
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;
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.