IOUG Collaborate – Monday

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.

Advertisements

2 thoughts on “IOUG Collaborate – Monday

  1. Tyf says:

    I agree about Messina – definitely the most dynamic speaker in the conference. I learned a lot from this session, which is funny because it definitely wasn’t one I was specifically looking forward to.

    I’d say I learned the most from the RAC BoF … amazed how much just DBA’s chatting with each other can give the most insight into immediate needs.

    • tylerv says:

      It’s rare that I note the name of a consulting/services company (after years in mgmt my name and number are still out there and cold-called FAR too often so I’m usually in ignore-vendor mode), but TUSC definitely caught my eye at IOUG as smart people who could help us setup one-time hard things right (or validate our ideas about how to do it).

      I missed the RAC BoF, dang. Note to self for future confs — if all the papers are available online, then go to all the panel discs — those are the ones that don’t have their proceedings published since they are free-form.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s