Oracle MVA

Tales from a Jack of all trades

Archive for September 2010

OOW 2010 – Day 2

leave a comment »

Well yesterday ended disappointing. The cruise hosting the ACE diner left at 8:05 PM *exactly*. My cab got stuck in traffic causing me to arrive at 8:07 PM…. This left me with no other option then to turn in early. The upside of this is that I slept good, causing me to be fresh and fruity today.

After meeting with one of my clients, I decided to skip first session and to start my day at a session called Tuning Your SOA Infrastructure for Performance and Scalability. It covered a lot of anti-patterns in SOA which are less interesting to me as a DBA, although I know that loads of developers don’t think about these patterns. Basically Cary’s session on Sunday covered the same subject. Dear developers, please don’t write code fast, write fast code instead. A DBA (or let’s call it an Oracle Administrator from now on) cannot change code or tune code when the design is faulty.

Oracle WebLogic Server and GridLink for Exadata was a nice and interesting talk about what’s wrong with multi data sources in my opinion. (This topic is the same topic I am supposed to talk about at the next developer planboard symposium) Now Oracle will release a new product called GridLink which will fix these issues. I will not go into details in this blogpost, please visit planboard at october 5th to find out more.

After some excellent chinese food, criteria for selecting the restaurant: there need to be roasted ducks in the window and chinese people eating, I went to the OTN party. Many thanks to Lillian for providing me with a ticket for my girlfriend. Sadly enough the security guys didn’t know that bloggers, press and speakers should be granted access without a ticket. I wonder how many other people ran into the same problem. At the time I was at the gate (round eight) there were are least twenty. Anyway my girlfriend’s ticket went to someone else in line (rather one in then none) and after a quick stop at the Benelux Cocktail Party at Lulu’s I went “home” to catch some more sleep.

Written by Jacco H. Landlust

September 21, 2010 at 4:25 pm

Posted in Open World

OOW 2010 – Day 1

leave a comment »

Today was the first day I spent on OOW 2010. Loads of people to meet, even more people tonight at the ACE diner. Apart from some really good sessions (thanks Alex, thanks Cary), I was at a session today that was interesting in a *special* way. I really don’t want to make fun of this character, but somehow I have to…

Somehow I still believe in the fantasy that people presenting at OOW (or any other site) know their stuff. Presenting about AWR and ASH without having the faintest clue about the theory and techniques behind ASH and AWR is shocking to me. Obvious wrong conclusions were presented like facts, statistics based on sampling seems difficult. Looking around and seeing people making notes at this session made me wonder if people were making the same notes as I was (mostly: this guy is so wrong), or if those people really will start tracing awrrpt and build their own “custom” spreadsheets with false information.

People please! Enterprise Manager contains the exact information that was show to you. It shows all this information in a graph, which will still work accurately with Oracle 11.2, 12 or 13 and you don’t have to invest a couple of hundreds of hours in developing this tool. Choose right! (and if you really want to build your own custom stuff, listen to a session of Doug Burns, JB or Graham Wood about AWR and ASH before building your “stuff”).

Written by Jacco H. Landlust

September 20, 2010 at 4:13 am

Posted in Open World

Small things you notice

leave a comment »

In the past you always had to remember to start your database services after you (re)started a RAC database. To automate this I used to create a script in $CRS_HOME/racg/usrco.

Just today I noticed that Oracle starts your services automatically when you have GI version 11.2.0.2.0. Can’t say for sure this is also the case on 11.2.0.1.0.

Yet another custom script can be trashed, I start to love default more and more every day 🙂

Written by Jacco H. Landlust

September 15, 2010 at 1:26 pm

Posted in CRS, Dataguard