SimpleTalk have just published another of my SQL Server articles – which talks about storage methods and block dumping in SQL Server, and ends with the suggestion that the reason that SQL Server DBAs seem to be very keen on “clustered indexes” may be related to the fact that SQL Server doesn’t seem to handle [...]
Here’s something you probably don’t want to say at the start of a public presentation: “Does anyone have a laptop I could borrow for the next 90 minutes.” I’ve just done my first ODTUG presentation – and everything I do runs under VMWare, which simply refused to start. I’m in my room now trying to [...]
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…
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:
I hope I’ve shared you some good stuff Enjoy!
The following question came up in an email conversation a little while ago: Are you aware of any problems a large oltp site might have with running index coalesce during production hours, as opposed to doing index rebuilds in a maintenance window? The main overhead with index coalesce is that it generates a lot of [...]
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.
I wish more people were aware of problems like this: Error found on Internet! Filed under: humour
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?!?
Thank you all those who attended my presentation - "Under the Hoods: Cache Fusion, GCS, GES and GRD". I hope you found it useful. Here are the demo scripts I used during the session, if you want to play with on your own system.
The actual presentation itself will most likely be available at a later date on the oracleracsig.org website.
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.
This is just a short note to point out that I just uploaded a new version of the scripts related to TOP. The new ZIP is available through this page.
The change log is the following: