Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

What can I say…?

There are (probably) more important things out there, for example, my daughter has twisted here knee-cap and me being here in Washington DC makes me a bit worried if all is well in Holland (be assured, I have called multiple times, but its not the same as being there) .

ACED Also doing this dedicated Oracle XMLDB stuff since 2003/2004, being an “evangelist”…colleagues within AMIS probably have no idea how fast they will have to run again when Marco is starting about:

“Oh, I could do that with Oracle XML DB much more easier via…”

…but in all, I can’t help myself and its worth it. Its all about passion, no title really needed, I will do it anyway.

So during ODTUG, after signing up for some extra ambassador duties, I could add an extra ribbon which I really appreciate because I know that the people who nominated me, don’t nominate someone very easily. I’m honored and really appreciate it. It will help with getting people more into Oracle XML DB.

My thanks go out towards the Oracle XML DB Development team who kept supporting me despite I can be very “intensive”, as a Dutch friend described it lately, and those colleagues that still want to know how this all works in Oracle XML DB (they haven’t given up on me yet, me being a “mental case”).

There is so much I still learn from them and others and they really help me focus. Said that, of course this also counts for the other OakTable “intensive” passionate people out there…

Hoped to be of help and more to come…

8-)

SQL Server 4

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 [...]

Stress Test

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 [...]

The “Not a Problem” Problem and other related stuff

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..

[blip.tv ?posts_id=3742672&dest=-1]

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..

[blip.tv ?posts_id=3740794&dest=-1]

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 </p />
</p></div>

    	  	<div class=

Coalesce

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 [...]

Starting a Holiday (/Presentation) at #ODTUG

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

room / meanings

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.

;-)

Errors

I wish more people were aware of problems like this:  Error found on Internet! Filed under: humour

My favorite parts of today

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?!?

RACSIG Webcast on June 24th Files

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.

Another SQL*Plus thing I learned...

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.