First day of IOUG was great! Lots of good sessions, saw some interesting products in the Hall, learned a lot.
In particular Michael Messina from TUSC led a great session on 11g RMAN features; he is a very dynamic presenter. The features that will be the most useful for our shop are:
- defining sections for large datafiles – these are like ‘sub-channels’ in that through 10g, you can define multiple channels, but PER DATAFILE this is a single thread; now you can backup large datafiles in parallel as well using sections
- fast incremental backup of physical standbys (they now do BCT) … this is above and beyond the loveliness that is a readable physical standby (says the guy who works with logical standbys a fair amount)
- block repair of production from physical standby
If you have the disk space, a physical standby of every database is starting to sound like a Good Thing ™. Sounds like cool improvements to duplicating databases and other things, but we don’t use those as much. (I think many of these new features are discussed here.) Side note: he did an informal poll from a packed room of DBAs on who was using flashback. Looked like about 1/3 to me. #1 gripe was disk space to run it. From the number of people who said they had turned it on then back off again, I think having a decent formula to estimate FRA before turning it on as well as better ROI for why it is needed is crucial to people feeling confident in moving forward with flashback.
Daniel Stober did a great job with his SQL Brainteaser session; it isn’t easy to put your code out there as a good way of doing something and he did it with openness to new options and some interesting questions. His original idea to release a SQL puzzle each month to help foster better SQL writing among developers is one that I may take home and see if we can get started.
Gary Gordhamer explained NLS very well, I understand it much better than I did before. I will probably suggest that we change our standard for how we create new databases due to what I learned. One tidbit: windows desktop created war files from developers can keep nls_lang settings from the windows machine and hose things up royally, as in data-gone-for-good royally.