Kevin Kempf's Blog

April 26, 2010

Collaborate 10

Filed under: 11g, 11i, Oracle — kkempf @ 3:03 pm

Arrival & Pre Conference

We arrived in Las Vegas Saturday morning, and promptly went to the Hoover Dam after getting some lunch.  Highly recommended, it stands as quite a feat of engineering and well worth the 3 hour detour.  On our way back to Las Vegas from the Dam, we stopped for a unique experience at the Gun Store.  Once again, in the adult playground city where money talks, this was well worth the stop.  How many chances will you ever have to fire an AK-47 on full auto (and not have to clean it afterward)?  After walking the strip, and having a fantastic meal at Mon Ami Gabi, the jet lag caught up and we crashed for the night.  On Sunday, we picked up our conference materials, and began planning in earnest for the rest of the week.  There were a handful of interesting looking sessions, but to be honest I was put off by the 6 hour blocks on some of them.

Conference Sessions

I attended the following sessions, for a variety of reasons.  I’m not going to critique the sessions, but I will summarize in bullet points

3398 XML Publisher and FSG for beginners

  • financial applications about put me to sleep, glad I’m not an accountant
  • XML Publisher is free with 11i if used only against Oracle tables.  The second you point to a custom table, you’re buying the whole product
  • Current version is 5.6.3
  • 11i has about 500 XML publisher templates, R12 has all (most) templated (2700+)
  • Office 2007 (Excel) may have issues unless you enable macros manually for FSGs
  • R12 requires web ADI

3238 EBusiness Suite in the Amazon Cloud

  • Completely unsupported by Oracle (as of yet), but perhaps a viable way to bring up and tear down non-production environments
  • latency could be an issue
  • uploading your whole database and apps tiers may not be viable (send media to Amazon)

4777 Latest on the E-Business Suite Technology Roadmap

  • News to me, but has been announced for some time (last June), the first year of 11i extended support is FREE and goes into effect this November
  • 6i patchset 20 (terminal release) is forthcoming
  • Weblogic Server for R12.3/R13 sounds like it’s in the mix
  • Old -> Preferred:
    • Discoverer -> OBIEE
    • Portal -> WebCenter
    • SSO -> Oracle Access Manager
  • EM 11g would be out, announced on 4/22.  Surprise!  It uses WebLogic Server 11gR1 (no surprise: the version doesn’t match it’s actually version 10.3.2)
  • Met Steven Chan and shook his hand after the session.  He didn’t hit me, nor call security, so I guess I’m not annoying him too badly.

4746 Replacing Discoverer – is OBIEE Your Only Option?

  • Surprise!  It’s not!  And this vendor (EIS) will tell you about their product
  • This product is kind of like OBIEE light, and essentially provides you with a bunch of canned reports and business views in your ERP

710 Deep Dive – Oracle Database 11g Performance Monitoring, Upgrade Testing and Tuning

  • I must have been a little tired, but I need to look into SQL Plan Baselines, which supposedly survive optimizer changes in ways that SQL profiles do not.

504 Trends in Database Administration and the Changing Role of the DBA

  • Touchy feely session on how DBAs are a valuable commodity.
  • Functional areas are important as the technology gets more complex every day

715 Understanding SSD Technology for Databases

  • There’s more to solid state disk than just sticking it in your SAN
  • Performance comparisons were made between conventional disk, flash, dram
  • SLC v. MLC

717 Enterprise Manager Grid Control: Moments of Truth

  • Interesting session about using EM for more than just database monitoring (I trust this so little it was nice to see someone using it)
  • Many of the folks in class wanted to swap “war stories” and it was nice to see everyone has the same problems with this product

3381 Release 12 Technical Introduction – Intermediate

  • This was kind of a bust.  At the onset, the speaker told people who had done this upgrade to leave as it would be review
  • It turned out, it was really introductory, like the stuff you can get by reading the R12 basic documentation

4243 Life Fitness Gets its Warehouse in Shape with Oracle Mobile Supply Chain Applications

  • I attended this because we’re looking hard at implementing Mobile Supply Chain Applications for our production floor
  • I don’t understand functional dialogue speak, it’s probably like when they sit in on an technical database session

3512 How to Manage Customizations Using Application Change Management Pack for E-Business Suite

  • This product looked interesting, until informed that it sat on top of the Applications Management Pack (which I refuse to pay for)
  • It not only tracked your customizations, it could also do functional setups
  • Seemed ideal for a very large organization

364 Advanced Dataguard – Fast Start Failover Configuration and Management

  • Good technical session from an Amazon A9 DBA.
  • We don’t use FSFO, and there’s 2 things in my way (DBWR to ship logs instead of the listener process, and using the FRA) but it’s worth a look
  • Doesn’t play well (or at least not automatically) with 11i; still requires manual intervention to failover the apps tier
  • Well said: when the @*#! hits the fan and you need to fail over to your standby, you’re most apt to make mistakes because you’re under stress, have a bunch of systems down, it’s the middle of the night, etc.  This eliminates the potential for errors.

Las Vegas

Just surrender your wallet at the airport

  • Dining in Vegas is EXPENSIVE.  Seriously.  We ate cheap one night at Dicks Last Resort in Excalibur and got a dinner bill for $60.
  • Louie Anderson is pretty damn funny.
  • Everything in Vegas looks close, until you walk there.
  • Riding insanity was a hoot.
  • Dear Luxor: If you’re not going to provide wireless, please don’t put the 4 foot ethernet cable by the TV, and the desk 10 feet away.
  • Unsurprisingly, the fitness center in the Luxor was woefully small.  Surprisingly full on a Sunday morning at 8am.
  • Who pays a $30 cover to get into a bar?
  • It’s really dry there, I was always thirsty.
  • OAUG put on a nice Sunday Night 20 Year birthday party for itself.
  • Unsure why they went to a cash bar for their premier event on Wednesday night, but if I’d paid $75 to get into that debacle I’d be in line for a refund.

Closing Thoughts

In the end, I was pleasantly surprised by Collaborate, this being the first time I’ve ever attended.  I have only Open World to compare it to in terms of large technical conferences, and it stands up reasonably well.  It certainly didn’t have the machine-like efficiency of Open World, but that didn’t really detract much from the overall content experience, it merely caused minor annoyances throughout.  Examples are their lackluster online scheduler (really awful, with no option but to print), lack of change notices via email, or general confusion around how to find a conference room.  Still, for about half the cost, it’s hard to pass on, and will be something I hope to attend again in the future.

Blog at