Back in 2009 I posted a script which I found very useful to review ASM disks. I gave that post the low-key title of The ASM script of all ASM scripts. Now that script has been improved I have to go a bit further with the hyperbole and we have the The Mother of all ASM scripts. If it ever gets improved then the next post will just be called ‘Who’s the Daddy’.
The UKOUG have done really well in organising the next Database Server SIG. It is being held at the City of Manchester Stadium – the home of Manchester City. That is the group of players bought on the cheap and managed by Roberto Mancini into the best team in Britain as will be proved when we win the Premier League in April.
They have got two of the worlds’ top Oracle speakers on stage. Actually that is slightly incorrect. They have one of the worlds’ top Oracle speakers talking twice and me also on stage.
The agenda looks very strong
11G introduced incremental global stats and the table WRI$_OPTSTAT_SYNOPSIS$ contains synopsis data for use in maintaining the global statistics. This table can grow very large and Robin Moffat has produced a good blog post about the space issues - note we both worked at the same site so it is the same DW being discussed by both of us.
WordPress send out a nice email with lots of details about your blog in the last year. Apart from visits growing month on month two points interested me. My most popular posts were all written several years ago and the ‘purging stats from SYSAUX’ is definitely my most widely read blog post. The reason for later posts not being as popular is that they are not as detailed. That is due to my change of role where I am managing a lot more and not having the time to devote a day or more to a problem and put up a very detailed analysis.
It is not often that I would post just to mention someone else’s blog but there is always a first time.
In the idle time that generally happens between Xmas and New Year I was catching up with various mails that I had marked as ‘follow-up – today’, which is quite a misnomer for me as I rarely follow-up and never on the same day. I came across a post from Karl Arao on Oracle-L in which he mentioned a script stored on a site he runs.
The final day of the 2011 UKOUG conference and it was straight in at the deep end with Joel Goodman talking about automatic parallelism in 11GR2. The talk was full of information, as Joel’s talks normally are. He also had time to cover Parallel Bulk Update which groups sets of rows into chunks. Each chunk can have a success or fail independently of other chunks which removes the ‘all or nothing’ approach normally seen with PDML. He has a good blog entry on this which is well worth perusing if you are interested.
Day 2 of the UKOUG conference at the ICC in Birmingham and back into the fray.
First up was Thomas Presslie talking about Dataguard fast start failover. How he managed to demonstrate transactions and network connectivity using whisky and toilet paper could not be done full justice in a blog – it had to be seen to be believed.
The first day of UKOUG conference at the ICC in Birmingham and there were a lot of familiar faces are around. Due to a lot of traffic I missed the first presentation I wanted to see which was from Kyle Hailey on SQL tuning. I will have to download the presentation later. I did make it to Greg Rahn on the SQL Monitoring report and that was well worth the time spent. Whilst I am familiar with the functionality, he opened my eyes by providing a number of examples of what he would look at first to try and determine a better resolution.
Much off the following diagnosis was performed by a colleague Scott Chisholm. The outcome is a lot of new information (to me at least) about the parameter _small_table_threshold but I have also developed thoughts around which set of checks we should put in place after restarts of major systems.
We start of with the executive summary for those that like to cut to the chase.
All of these items refer to Dataguard standby databases on 11GR1 and the active dataguard license comment is applicable in 11GR2 as well.
LGWR: Insufficient standby redo logfiles to archive