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;
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 :)