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
Whilst ensuring that Resource manager was working properly I noticed a problem that it seemed to be dropping out of the plan I wanted to run ( DW_PLAN) and returning to the default plan whilst in the automatic maintenance windows.
One of the benefits of presenting at UKOUG, whether it be a SIG or the Conference is the feedback received from the audience via the questionnaire. I received mine for the ADR presentation I did at the Unix SIG recently. I was pleased to see I received very positive marks and the comments were supportive. Probably the most important factor to me was the marks given for presentation skills which were good and seem to get better with each presentation, which should not be too much of a surprise.
I was pleased with my the presentation on ADR I gave yesterday at the Unix SIG in Reading. The timing was bang on at 60 minutes and the audience had not seen or used many of the features I discussed so that was a bonus. I had the benefit of being able to give the same talk two days earlier to a team of DBAs at work and I learned a lot from the comments I received and that made for a better presentation yesterday.
I am presenting a talk around the use of the Automatic Diagnostic Repository at the UKOUG SIG in Reading on 22nd September 2011. I will be covering, amongst other things, the management of files, the Health Monitor, incidents and problems and the Support Workbench utility. I am hoping that, whilst everyone will probably be already aware of ADR, some of the things I mention might be new or have not been fully looked at before.
You run a manual ADDM report for the most recent snapshot and it never finishes.
You notice that in the performance tab (historical data view) for the same database there are no ticks in the box that shows an ADDM report is available.
Creating a snapshot report takes an inordinately long time, even when the system is not that busy.
What do you do?