Oakies Blog Aggregator

It’s been a while since I visited the Sun Video RSS feed and I found some interesting videos related to performance that are worth sharing and something you could watch over a big cup of coffee..

First is titled Performance: The “Not a Problem” Problem which I could also relate when doing performance analysis for example…

• When a client instantly jump into conclusion that the performance degradation is caused by the database link well in reality when everything is measured/profiled it turned out that it’s because of the slow IO subsystem..
• Or when the Data Guard environment was being blamed because of the slow batch processing but when everything is measured/profiled it turned out that it’s the bad SQL..

there are lots of interesting customer scenarios we could imagine.. but if there would be a systematic approach, a clear problem definition, and measuring the right stuff.. then things would be better..

Second is titled Performance: Experimentation which highlights the importance of the test cases and isolating the problem.. and how this could make a good learning experience while also solving the problem..

Third is the series of videos titled “Little Shop of Performance Horrors” posted on this blog post and tackled about these horrific topics:

• The worst perf issues I’ve ever seen!
• Common misconfigurations
• The encyclopedia of poor assumptions
• Unbelievably bad perf analysis
• Death by complexity
• Bad benchmarking
• Misleading analysis tools
• Insane performance tuning
• The curse of the unexpected

I hope I’ve shared you some good stuff Enjoy!

Time flies. Had a great weekend organizing an AMIS Query, an internal course with Doug Burns, looking at soccer games with Doug and Jacco and now already posting from a Marriott hotel room in Washington DC for some activities during #ODTUG

Its still a bit “quiet” (tons of elderly citizen though) in the Marriott hotel regarding conference meet-ups and/or other things, but met last night with Stanley, Debra, Alex, David (Mr. aPex) and for the first time with Sheeri (Kritzer Cabral) and her husband. Forgot his name (after 2 Guinness and pushing 36 hours “to get into the timezone”) but, man, can he draw cool “caricatures“. He had his own caricature book with him reflecting pictures of Magicians during a “Magicians Conference”, all signed by them and/or commented on. Great book/sketches and had a good laugh on how modern “Magicians” are nowadays that they have their annual conference as well…

Its Saturday now, its hot outside and humid (cloudy) and approximately 35C (95F) and I’m almost off with my nephew Rob, who I dragged along this time (if not only for those soccer matches), to see Washington DC. At least I don’t have to prove to my nephews Chris and Rob that I have been there by jumping with my trousers down on the White House lawn and doing so making a Dutch TV premier (getting to old for that stuff anyway).

Oh yeah, almost forgot, its the start of my Holiday, on Wednesday my ODTUG presentation and for the most just enjoying Washington DC before I leave with my daughter towards Switzerland in 2 weeks time.

Every night over dinner my daughter asks me "what was your favorite part of the day Momma"? Well, tonight I had several favorite things to share. My first favorite was that I found an Oracle bug that has to do with subquery factoring (I'm going to blog about this one soon). And my second favorite (well, it's really my *most* favorite) was spending some fun time at the beach with my kiddo. Looks like we had fun doesn't it?!?

In the past, when you exit SQL*Plus, it would always commit - there was an implicit "commit work" issued for you right before it would disconnect your session.

It has always been that way. It doesn't have to be that way anymore as of 11g Release 2.

There is a new exitcommit setting - it defaults to ON which is the way it has always worked. But now you can set it to OFF which implies that a rollback will be issued instead of commit.

Things change over time... If you rely on SQL*Plus committing upon exit - if you have a script that relies on that, bear in mind it is no longer "a fact", it is highly probable that SQL*Plus will commit when you exit - but not a sure thing like it used to be. Yet another new thing I learned while updating the book Expert Oracle Database Architecture. I was just reminded of it today while I was going over the proofs of the chapters...

See http://download.oracle.com/docs/cd/E11882_01/server.112/e10823/ch_twelve040.htm#BABEGEGC for details on exitcommit.