Oracle By Example Series for 10g Release 2

Last month I posted “What’s New in” series on But for some of us reading is not the best way for learning, and we have another excellent resource with Oracle;

You can use this page to play mini lessons to learn how to use various new features of the Oracle database, and they keep adding demos to this site on a regular basis and it was Last updated at 01-Feb-2007.

Another Oracle ACE was our guest in Istanbul

After Mr.Jonathan Lewis and Mr.Julian Dyke, Mr.Lutz Hartmann was our guest for a two days seminar. I had very nice time with Lutz, and the seminar was very useful, I will be sharing my notes’ highlights like I did before for the other seminars.

First of all I want open some questions I noted during the seminar for your comments which I will be researching;
Q1> what affect does cache option has in lru list positioning?
Q2> in plsql if we define a variable with the same name of a column and use it at where clause will it raise an error or bring all rows; “declare empid …; begin … select …. where empid = empid; ..”
Q3> does alter system buffer cache flushes nK pools also or just the default one?
Q4> how does a pkey affect a count(*)
Q5> is %10 stale option hard-coded, any hidden parameter for this
Q6> is also dictionary stats included to the auto stale statistics gathering job

And here are my notes from this very nice seminar;

Seminar Notes : Inside Oracle 10g by Lutz Hartmann

After the seminar let me say it again if you are still not using or planning to use 10gR2 you are missing so much, also you need to use RMAN and EM, these are great and they will ease your life believe me.

Lutz thank you again for this seminar, hope to meet you again :)

A small sql puzzle

One of my friends asked me this question, it is a small sql puzzle, we have a table in the below organization;

create table tr_football_league
( club_id number,
club_name varchar2(32),
championship_year number(4), — only the year
year_100th_champion number(1) — 0 false, 1 true
) ;

the data to be inserted is here
insert into tr_football_league (1, ‘FENERBAHCE’, 2007, 1) ;

so the wanted sql must return which club was champion on its 100th year and also owns the most championship count in the data mentioned above. the answer is so easy, it is my precious club FENERBAHCE, but what do you think about the sql?

This love will never end :)

Oracle Maximum Availability Architecture(MAA)

Oracle Maximum Availability Architecture(MAA) is Oracle’s best practices based on proven Oracle high availability technologies and recommendations. The goal of MAA is to remove the complexity in designing the optimal high availability architecture;