These days, the DOAG Conference 2009 happens in Nuremberg, Germany. First day was yesterday, Tuesday November 11th 2009. This is a machine-readable copy of my scratchpad, coming from the different talks I attended.
- Sun Oracle Database Machine Exadata 2: The “Quarter Rack” (consisting of 2 Servers and 3 storage nodes) sounds interesting.
- 11gR2 has some features only available with Exadata: For example, a special “Storage Index”, grouping several lines with theit MIN and MAX values in order to minimize scan ranges (called Smart Scan)
- Exadata provides inter-instance IO ressource management possibilities, it might be useful to look at the IO ressource management capabilities of 11g without Exadata as well!
- Really interesting stuff was “Righttime Data Warehousing – reducing latency” of Sven Bosinger; his presentation and the paper will be great material to explain some stuff for conceptional discussions. Thanks, Sven!
- Look at issues for your DB release version! Metalink Note 161818.1 is great for that!!
- Flashback Data Archive may be a good tool for an archiving concept (Oracle sales tells us about Basel II and stuff), but have care!Firstly, DDL on tables prepared for FDA is slow, and secondly and worse, if you have tablespace quotas on your schema, the archiving might stop if it’s full. And that without error messages due to asynchronous archiving. Only way to monitor that is to scan for new trace files all the time. 🙁
- The new Oracle Grid Infrastructure and its Instance Caging sounds interesting as well. Especially the CPU assignment with CPU_COUNT parameter sound nice, as well as CPU overcommitment (assigning more CPUs than you have).
- Oracle OMotion and RAC One Node are other nice ones: But at the moment, RAC One Node is not available with Standard Edition!
At a glance: The first day was great, and absolutely interesting. Let’s see what Wednesday brings, the program looks promising so far.
Best regards from Nuremberg