I will completely get lost for the following two weeks, I will try to stay away from Oracle and Internet, plug back to life, especially to my family. Before my departure I have some notes to share;
1. Steven Feuerstein was in Istanbul for a two days seminar, The Best of Oracle PL/SQL. Unfortunately I couldn’t attend to Steven’s class so no seminar notes to share this time, but Steven’s all presentations can be downloaded from here.
As Steven mentioned after his seminar we had some great time together with Steven, he is a real legend :)
2. There are 184 registered people for our FREE “Why Oracle?(10g Release 2)” seminar on this Saturday. After all the feedbacks following was our final content;
11:00 – 11:50 / H.Tonguç Yılmaz
Oracle Database Concepts
Locking, Concurrency and Multi-Versioning Concepts, NULL value with Oracle
13:00 – 13:50 / Özgür Macit
Oracle Database Advanced SQL Options
Analytic functions, Hierarchical Queries, Model Clause, Regular Expressions
14:00 – 14:50 / Ersin Ünkar
Oracle Database Options
Flashback, Cost Based Query Optimizer
15:00 – 15:50 / Hüsnü Şensoy
Oracle Database Backup&Recovery Options
Recovery Manager(RMAN), Flash Recovery Area(FRA), Automatic Storage Management(ASM)
16:00 – 17:00 / Ogün Heper
Oracle Database High Availability Options
Real Application Clusters(RAC), Data Guard
It is a very cold time for Istanbul so hopefully I expect to have ~100 of these students attending at most and up to the RAC session at most 20 of them will be still alive with us I guess :) And also we had a poster this time!
With FETCH_THREADS parameter one table, partition or sub-partition now can be divided into pieces and each FECTH THREAD reads its own region in this release. Initial tests shows that this way ubSQL is even faster than Oracle’s own Parallel Query :) This is mostly because with PQ even we have N slaves one will do the FETCH and others have to wait on the Query Cordinator. But with FETCH_THREADS parameter of ubSQL we have N real sessions, each fetching, so no contention.
I will be blogging about ubSQL more later, for now please check this presentation, download and test it at your own environment, available platforms are HP-UX-IA64-B11.23 / Linux-2.6.9-5-X86-64 / SunSolaris-Sparc64-5.9 / Tru64-5.1
4. Last weekend we studied Jonathan Lewis‘s latest book Cost Based Fundamentals of Oracle and as I promised the presentations we prepared are shared here. They are Turkish mostly of course and you need to be a member of this Turkish Oracle Users Group to download them, sorry :)