Tuesday, May 5, 2009

COLLABORATE 09: OAUG - Jan Wagner

I had the opportunity to interview Jan Wagner, the past president of OAUG (2007 and 2008). This was my first interview, ever. I was nervous and didn't want to ruin any future opportunities, so I came prepared. Well, I thought I had. All my notes were online and I could not get a connection in the Press Room. Thankfully I got there early, I even skipped the ApEx SIG - Ask The Experts panel (John Scott, David Peake, Dimitri Gielis, et. al). After fighting with the stupid computer for 30 minutes, I just decided to write down my questions so I wouldn't look like a complete fool.

As I write, I'm still debating on the format, so I may switch between the narrative and a Q&A style. So bear with me.

First, Mr. Wagner's bio
Jan Wagner, OAUG (past) President

North Atlantic Treaty Organization

Board member since 2004

Jan Wagner is the immediate past president of the OAUG and currently is an OAUG board member for 2009. He was first elected president of the Oracle Applications Users Group (OAUG) in January 2007 and was re-elected the following year. As a member of the OAUG since 2004, he has spent the last several years on the OAUG board of directors.

Wagner is currently the chair of the Communications Committee. He previously served as the co-chairman of the organization’s Pricing Council, chairman of both the Governance and Finance committees and treasurer of the Executive Committee.

A native of Denmark, Wagner currently serves as the branch chief for operations and internal review for the North Atlantic Treaty Organization (NATO). In this position, he oversees the management of the Oracle E-Business Suite as well as financial planning and corporate governance at the Allied Maritime Component Command Headquarters Northwood outside of London.
Let's start with the basics. There are 2,000 Member Companies in OAUG. Unlike IOUG, OAUG is made up of Member Companies. A company signs up and all of their employees have access to the OAUG resources. Individuals are a part of OAUG, but their role is usually that of a one-person consulting company. Thirty five (35) of the top 100 on the Fortune list are members. Funny, I asked what percent that was. Um, 35? Yeah, I know.

I'm fairly new to the conference/group world. I am a passive member of SOUG and have presented there. I've never been real clear on the differences between IOUG and OAUG, so I asked. Paraphrasing Mr. Wagner:
OAUG's main focus are the applications, Siebel, PeopleSoft, Hyperion, etc. The majority of members are from the Business side like Accountants or HR, but there is definitely some crossover in that some of our members are Information Technology (IT) professionals. Mainly Business types or Power Users.

IOUG is more database specific and the members are DBAs or Developers typically.
. Since OAUG is application related and Oracle is trying to take over the world (of software), I thought it appropriate to ask him how they manage all those acquisitions. Again, paraphrasing:
It's not easy (laughs).

We work with Oracle very closely to integrate the new application users. In some instances, they have independent groups and others are supported by the particular vendor. Siebel for instance fully supported their user groups providing all the necessary resources including content. Independent groups (like OAUG) are community driven in that the users are the experts and provide the content (educational sessions and such).
I had other questions but I believe I captured some of the most important points. OAUG, through their Customer Support Council, has done a fabulous job of keeping pace with the Oracle acquisitions and integrating the respective user groups. Oracle, through their Global Customer Program, has provided the necessary access to OAUG to help accomplish their mutual goals.

I'm spent. That's the most thinking I've done on an article in awhile. I tend to just write what's on my mind. I know it's not perfect and could probably be better, but I'm happy with the result.

View my notes on the interview here.

Let me know what you think. Do I have the chops to pursue a career in journalism or should I stick to my day job? Be honest...brutally honest. It'll only make me better.

COLLABORATE 09: SwingBench

Session: Q352
Presenter: Debra Scarpelli
Time: 12:15-12:45
Room: 224 G
Title: A "Stress-Free" Free Stress Testing Tool From Oracle

I saw this on the schedule "free" jumped out at me. I don't believe the schedule made any mention of the tool, but I could be wrong.

Swingbench

I've read or seen about this somewhere but never got around to investigating it.

For those that don't know, it's a level load testing tool for the Oracle database. It was written by Dominic Giles (of Oracle). It has been used by Oracle internally for a time that I am unable to determine. You can find the page for it here. This tool is free but it is not supported by Oracle.

Specifics
- Currently works against 9i, 10g and 11g
- Built in Java and works on Unix, Linux and Windows
- Can use against RAC, TimesTen and Stand-alone databases.
- Three interfaces, command line (charbench), a mini GUI (minibench) and SwingBench (full fledged GUI)
  - SwingBench interface provides real-time feedback

There are 4 supplied (pre-configured) benchmark tests:
- Calling Circle with a read/write ratio of 70/30
- Order Entry with a read/write ratio of 60/40
- Stress Test with a read/write ratio of 50/50
- Sales History with a read/write ratio of 100/0

You can also write your own.

To run it you need to have Java (not sure which version) and the Oracle client installed on your machine. The output is xml so you can do pretty much anything you want with that.

There are some other tools that you can use in conjunction which you can find on Dominic Giles site.
- Data Generator
- BMCompare (yes, I snickered too) which compares the results of 2 benchmark tests.
- TraceAnalyzer

Pretty cool little tool. I'm definitely going to give it a try to see how it works and what it can teach me.

COLLABORATE 09: Day 1 (Wrap-up

The exhibitor hall opened up at 5 PM (EST). I've been to two conferences so far...Open World (2002) and this one. Wow. All the cheap schwag I could handle, including 2 really annoying monkeys that make really annoying sounds (which will eventually drive me crazy, but not yet). Sushi. Indian food. All the (brie) cheese I could ever want. Beer.

The last being the most important of course. Beer. Mmmmmm...beer.

I walked around for an hour and couldn't find anyone. Finally, I took off my "nice" shirt to display my ORACLENERD shirt and within 5 minutes found @jdanton. The @dannorris walked up like he knew me...he doesn't look like his twitter profile picture. I was looking for some guy with a big coat tugging on the collar.


It took me a second to realize who it was. Nice to meet you. I read earlier that he had been recently acquired (hostile takeover) by Oracle.

Kris (wifey) joined me right after it closed and we headed over to the Peabody where I got to meet @toddsheetz (best...last...name...ever). I have this sneaking suspicion though that my wife was a bigger hit than I was. She's a tad better looking than I.

Met David Peake of ApEx fame. He's the Product Manager for ApEx and gave the Oracle Forms conversion presentation I attended earlier. He's a hoot.

Then I saw a shiny object which I wanted (for LC), but it was attached to some girl. She wouldn't give it to me. Bollocks.

Nice 16 hour day though. Learned a lot, had fun and met some great people. Looking forward to tomorrow.

Monday, May 4, 2009

COLLABORATE 09: Other Stuff

I woke up late today so I missed the Charles Phillips keynote. I'm hoping to catch it online somewhere.

I've been to 3 sessions today.
Anatomy of a Database Attack by Josh Shaul
Data Security Challenge by Paul Needham and Tammy Bednar
Converting Oracle Forms to ApEx by David Peake

Not a bad day.

At lunch I saw Tom Kyte sitting by himself at a table in front of one of the giant OCCC halls. I did not bother him though some suggested I do so. That's why I am here right? To network and meet people? One person even suggested giving him an ORACLENERD T-Shirt (yes, I have a few).

Now I'm waiting to "network" with Dan Norris, Jeremy Schneider, John Scott, Dimitri Gielis and maybe Billy Cripe.

I met John and Dimitri outside the OCCC yesterday as I waited for my ride. I was one of John's first customers at shellprompt.net way back in 2005. I took my 75 page J2EE app and ported it to ApEx in about 2 weeks. It took 6 months to write the J2EE application.