Month: December 2008

December 6

DBA 2.0 What’s in a name…

I have the utmost respect of Graham Wood and the Team that is handling all the technology and expertise that is going on in DB Console or the Oracle Enterprise Manager. They did a great job over all those years and have given us great tools to work with, like ASH, AWR & ADDM.

…but…this presentation of Graham and his “DBA 1.0” and “DBA 2.0”, talking about all the great features (and demonstrating it) of OEM, really really irritated me. The world isn’t black or white and even if it would be that extreme, the whole world would have an opinion about it. I don’t know, maybe that is also the goal of this presentation, getting people to talk about it.

The Battle of the DBA's

The presentation starts by Graham putting out that OEM (AWR, ASH, ADDM, etc) is a great tool and, IMHO, he is absolutely right. So instead of doing the “normal” Oracle presentation thing, he presented two DBA people.

December 4

My presentation of 2nd of December during the UKOUG Conference… So what was in it? Mainly appetizers of how some useful things work and a little bit high level concepts. I demonstrated, I hope, new ways, with (some) foundations coming from XML DB functionality. How to interface with the outside world, for example, by directly saving and selecting from multiple XML files, on disk, from your database or getting or pushing data from/to the internet, like RSS data, getting data for your Google Maps API or easily setting up a SOAP web service.

So among others:

  • How to enable, disable the Protocol Server and to see its Status
  • Overview of the Protocol Server configuration file xdbconfig.xml, Its contents and meaning
  • Memory structures that effect the shared server and therefore also the Protocol Server
  • Protocol HTTP API’s like the PL/SQL Gateway, DBURI (oradb) and Native Database Web Services (orawsv)
  • An overview how the Native Database Web Services works + DEMO
  • An overview how the DBURI servlet works + DEMO
  • An overview of URITypes of  HTTPUriType and XDBUriType’s + DEMO’s
  • The possibilties of combining BFILENAME and XML, like selecting and save files directly from disk
  • An overview of Repository Event’s, how it works demonstrated via a simple DEMO
December 3

Its Wednesday now. 24 Hours after my presentation, which actually worked out well, but as Doug noticed I was prepping my presentation for Tuesday on Monday and didn’t allow me the time to see any other presentations. So my visibility during Monday on the UKOUG ICC grounds where nil. So in the end I skipped it all on Monday.

Tuesday

I was “scarred as hell” that one of my demo’s wouldn’t work out they way they should, or even worse, my laptop would brake down like the one from my Dutch peer Bernhard De Cock Buning. If I had allowed myself I would have attended Bernard’s presentation on Monday. It was the first time I embedded demo’s into my presentation and had a grant total of 8 examples to demonstrate.