My perfomance tuning workshop

Today I have delivered a specially tailored workshop in Zurich.
A few weeks ago Tom Kyte had delivered a Q&A session for a bunch of DBAs when he was in Zurich. I was booked for today to deliver a follow up as a workshop in order to discuss some details on memory management in Oracle database 10g.
We had a close look at ASMM (Automatic Shared Memory Management), Automatic PGA Management and the use of temporary tablespaces and temporary tablespace groups in Oracle 10g.
I had compiled specially tailored courseware from different Oracle University courses, such as the New Features for 10g Adminstrator, 10g Performance Tuning and some white papers and metalink notes.
I was teaching a group of about 15 DBAs who are very experienced and deal with very large systems of sizes in the 10s of terabytes.
We also had some very interesting discussions on some features which can cause headaches when upgrading to Oracle 10g, such as bind variable peeking, system statistics, and automatic statistics gathering and its possible effects.

connect lutz hartmann as sysdba

CS CRUISING ORACLE

Right after I had arrived from New Jersey I delivered a short training at a very special event which Credit-Suisse had aranged.
They had hired a ship on the Lake Zurich and invited their top DBAs to come and cruise Oracle for one day.

I had the first 30 minute slot and talked about New Features of RMAN in Orcale 10gR2.

All together there were five speakers on this event
amoung others
Christina Antonigni,

who talked about Automatic Segment Space Management

and Jonathan Lewis

who flew in by helicopter so that he could make it in time from his Indexing and Troubleshooting Seminar at the Zurich Development Center. He was picked up by the boat on the way.

Jonathan Lewis talked about the propper usage of V$ and X$-Views.

I got to know Lutz Fröhlich, who is an ORACLE 9i CERTIFIED MASTER and was recently hired by CS. He is the leader of the DWH-team now. Sorry, but I forgot to take a picture

connect lutz hartmann as sysdba

SOUG yearly meeting 2006

I’m delivering a 9i DBA part I class in Bern this week.
We skweaze the 5 day contents into 4 days,
so that I could take part at the yerly meeting of the
Swiss Oracle User Group on March 29th.2006 in Baden.
It took place at the ABB.

They have this impressing fountain at the ABB.
I enjoyed to watch it very much.

.

I was surprised to meet so many people whome I know from my trainings. It was fun to meet again in such an event. Specially dinner with a guy from Latin America who had im pressed me in a programing class about a year ago withhis capability to transform questings into SQL-statements straight away without having to think a lot. He had given me a hard time then and I had to invent new chestings again and again in order to no let him get bored.
It’s a pitty, I forgot to take a picture of him.

There were a number of very interesting trainings delivered about real life projects like the first experiences with Grid Control in large enterprises as the UBS,…

… the does and don’ts in an implementation of STREAMS

…and topics like security, LDAP & OID, DBMS_SCHEDULER…

I delivered a 90 minute training about the New Backup Strategy with RMAN in Oracle 10g, see my previouse post

connect lutz hartmann as sysdba