Tanel Poder is coming to the Netherlands to do his seminar “Advanced Oracle Troubleshooting for DBAs and Performance Engineers“. I enjoyed his sessions greatly during Hotsos and if you are one off the lucky who can manage to attend during the 2nd and 3rd of April, organized by Anjo Kolk’s Miracle Benelux, in Holland, please do, you will not be disappointed. Be quick though…a lot of seats have already been taken.
Have a look here for Registration, Agenda and General Info::
Be aware: its not about and is not a beginner database tuning course, SQL tuning or CBO course and you need a good understanding of general Oracle database architecture and OS commands. At the end of the course you will understand internals of core Oracle kernel components and their interaction with the OS. Also you will be proficient in systematic end-to-end troubleshooting, using the right tool for right problem and have the ability to proactively eliminate potential database performance issues.
HTH
Marco
Click the picture to enlarge
I had a pleasure to attend Tanel’s seminar in November.
I must admit it was a great fun and was really full of interesting and important stuff. It helped me to understand how Oracle internally works in much details.
This seminar is definitely “must-visit” for anyone who wants to know how exactly data is processed behind the scene in Oracle DB.
Totally agree. Maybe Anjo can share somoe light later on if there is still room.
Yep we have some seats left, around 6 or so.
You can apscmclioh the same thing with function based indexes in earlier versions of Oracle, I think from 8i.create table test (id number, inspection_dt date);create unique index one_per_day on test (id, trunc(inspection_dt));insert into test values (1, trunc(sysdate-1)+1/24); — OKinsert into test values (1, trunc(sysdate)+1/24); — OKinsert into test values (1, trunc(sysdate)+2/24); — ExceptionORA-00001: unique constraint (ODS.ONE_PER_DAY) violated