I was tasked by IOUG to organize the IOUG High Availability Boot Camp at Collaborate 12 conference. Today (March 19, 2012), I had an interview with Andrew Younger in IOUG to talk about the contents/topics on the High Availability boot camp. Here are the QAs of the interview: Andrew: For whom are your sessions designed? (Who will get the most value out of them?)
Sod’s Law part II (part I was a block corruption on production during the penultimate dress rehearsal): FIVE days before go-live of an 11gR2 upgrade, we’re hit on a development database by Oracle bug 13505390.
The symptoms of this are ORA-00600: [kkedsGetTabBlkCnt: null segment].
This is related to dynamic sampling in combination with some other features including deferred segment creation or interval partitioning.
In my particular case, it’s neither of those so the full extent of the bug is unclear. However, the good news is that the patch resolves the issue.
Ein kurzer Tipp zur Nutzung von "eigenen" Bildern als POI in ADF... dieses Beispiel basiert auf JDeveloper 126.96.36.199. Als alter Schifffahrtskaufmann hatte ich die Herausforderung, auf einer (Welt-) Karte die Schiffspositionen "meiner" Reederei darzustellen. Ich wollte diese nun nicht mittels "Fähnchen" oder den default "Bubbles" markieren, sondern mit einem "richtigen" Schiff. Hier zunächst das Ergebnis:
For the time being we are still sitting on 188.8.131.52.x on all our systems but that will be changing this year. Strong possibility that everything will move to 184.108.40.206.x at some point in 2012.
Our first system that may go live is currently sitting at 220.127.116.11.1 ( was just patched up to there with Jan 2012 PSU update ).
That system ... like all of ours is a non RAC system but is using ASM. Because of the change in 11.2 that means two separate oracle homes one for the Grid Infrastructure part ( including ASM ) and the other regular oracle home.
In the previous post I wrote about strangely behaving V$SQL. For some reason there were duplicate rows leading to wrong results issue when running DBMS_XPLAN.DISPLAY_CURSOR for a particular child cursor. I tried to reproduce the issue using simple test case – and it was reproduced.
Here it is. I’m starting to execute a simple query against DUAL while constantly changing optimizer environment, forcing Oracle to build a new child cursor for each execution:
Man, its been ages since I had free time to update the blog, what with birthday parties to organise, Roger Water concerts to attend and Radiohead concerts in the planning !! OK, time to take an initial look at Secondary Indexes for Index Organized Tables (IOTs). If the IOT needs to be accessed via the Primary Key (PK) column(s), [...]
...that's been bugging me for a while, about time I blog about it.This post is mostly for my own reference. Although of course it might be useful for the odd budding dba out there who still believes the command line is a useful weapon in their armory.Yeah, they do exist! I'm one of them, thank you.So, have you been using sqlplus of late? And been bugged by the default Oracle data format we all