home | français

Donnerstag, 24. April 2014
Fachreferate / Sessions
Neu im Angebot

Oracle University und Digicomp präsentieren
Jonathan Lewis: Indexing and Troubleshooting

11. und 12. Mai 2006 Wir freuen uns, dass wir Ihnen dieses Jahr im Mai ein zweitägiges Seminar mit Jonathan Lewis anbieten können.

Nutzen Sie Ihre Chance ! Treffen Sie Jonathan Lewis – DEN Oracle Experten!

Zwei Tage lang wird Jonathan Lewis in Zürich einen kundenorientierten Oracle Workshop zu den Themen Indexing and Troubleshooting abhalten. Sie bekommen die einmalige Gelegenheit, den Oracle Experten mit Ihren persönlichen Fragen zu konfrontieren. Das Seminar wird in englischer Sprache abgehalten.

Workshop Day 1

Indexing Strategies - Agenda
9:00 - 10:30
Session 1
The Structure of Indexes
What is a B-tree index, what is a Bitmap index and why is it so different? How does Oracle build indexes? Are there differences in reverse indexes, function-based indexes, cluster indexes, global partitioned indexes, indexed organized tables, and secondary indexes.With the aid of a few block dumps and carefully monitored test results we examine the way that different types of indexes are built and behave..
10:30 - 11:00 Break - coffee and informal discussion
11:00 - 12:30
Session 2
The Uses of Indexes
How many different ways can Oracle take advantage of an index. We have primary keys and unique keys - do we need unique indexes to enforce them. We may have problems with foreign keys if we don't have related indexes. We need fast access paths - but will indexing help and what will it cost? When will Oracle use an index to accelerate a query? Can we assist performance by understanding the mechanisms.
12:30 - 13:30 Break - Lunch and informal discussion
13:30 - 15:00
Session 3
Popular misconceptions
There are several surprising ideas floating around the Internet about how Oracle indexes work. Sometimes these ideas are irrelevant and have no use or impact. Sometimes they have a serious impact on your effectiveness. They may cause you to do work that need not, or should not, be done. They may introduce down-time that you do not need. They may make you avoid a feature that is really the perfect feature for your application. This session examines some of the more popular and potentially damaging misconceptions about indexes.
15:00 - 15:30 Break - coffee and informal discussion
15:30 - 17:00
Session 4
Maximum benefit, minimum cost
We all know that indexes are supposed to make things go faster - but sometimes we forget that they have maintenance costs - of two types. How do you identify the optimum set of indexes for your application? How do you identify redundant indexes? How do you check whether or not an index has become inefficient and needs to be rebuilt - and how do you rebuild it most cost-effectively? This session discusses strategies for ensuring that you don't waste effort supporting indexes that shouldn't exist, and don't waste valuable batch time rebuilding indexes that don't need it.

Workshop Day 2

Trouble Shooting and Tuning - Agenda
9:00 - 10:30
Session 1
Trouble-shooting or Tuning
What's the difference? What are the strategies. Why tuning is hard but trouble-shooting is easy. Key targets, indicators and mechanism for producing a well-tuned system on day one. Strategies for dealing with badly performing systems after go-live.
10:30 - 11:00 Break – coffee and informal discussion
11:00 - 12:30
Session 2
Frequently Occurring Problems
Some of the most commonly occurring issues that affect performance after a system has gone into production. Methods for spotting them, measuring the impact, and dealing with the cost / risk / benefit triangle involved in fixing them. Getting into the habit of pre-emptive analysis and pro-active fixing.
12:30 - 13:30 Break - Lunch and informal discussion
13:30 - 15:00
Session 3
Quick Fixes
Methods, workaround and dirty tricks for dealing with classic performance problems when the system is in production. There really aren’t many quick fixes that can be applied across the board – each one needs careful examination of costs, risk, and benefits. In this session we consider some of the options that are most likely to be worthwhile.
15:00 - 15:30 Break - coffee and informal discussion
15:30 - 17:00
Session 4
V$ and X$ -
It's a good idea to be familiar with just a few of the dynamic performance views - and there are a couple of items in the still hidden away in the X$ objects that can add a little value. This session will describe the views that are most commonly of use, and explain the meaning of some of the more obscurely named, but potentially useful items.
JL Computer Consultancy
Jonathan Lewis Biographical Information
My name is Jonathan Lewis and I live in the UK a few miles outside London - conveniently located for both Heathrow and Gatwick airports and an increasing international range of clients.

I have been using database software for more than 18 years, of which the last 15 years has been spent using Oracle. For the last twelve years I have worked as an independent design and trouble-shooting consultant. Much of the work I do is very short-term, often just a couple of days to investigate and comment on a troublesome system.

The systems I have worked on range from a single NT up to 128-node Pyramid RM1000, databases have ranged in size from a tiny (but violent) 50 Mb to 4 Tb with transaction rates from just 60 per day up to 4M per hour, and the locations have varied from 155W (Palo Alto) to 120E (Hong Kong).

I specialise in knowing how the database engine works. If you need to know which features of Oracle may be useful for your specific application I will be able to tell you because I spend a lot of my time investigating how well new features work and how easy it is to break them. If you need to make your system run faster, I can tell you what can be done, and what is most likely to be a cost-effective approach.

I have given several presentations each year to the UK Oracle User Group, both at the annual conference and at meetings of the Unix and DBMS SIGs. I’m also a regular presenter at the Danish Database Forum and I gave two presentations at the IOUG-A conference in 2003, which both were voted into the top 10. Whenever I can fit in with other engagements, I’ve also done various one-day events, or spoken at SIGs around the world.

I write fairly regularly for the UK user group magazine, and BMC’s online journal DBAzine, and occasionally for other publications. Most significantly, though, I am the author of Practical Oracle 8i - Building Efficient Databases, published by Addison-Wesley. The title is out of date – but a lot of the material is still relevant to Oracle 9i and 10g.

Last, but not least, I am the designer and presenter of the Optimising Oracle (tm) Seminar: an intensive three-day course designed to help you get the most out of the database engine. I have presented this course around the world, both as a public event, and as a private event for large corporations. The same is true for the one-day tutorials targeted at more specific areas of the database.

Room Reservation
For Room Reservations (11.&12.05.06. ) please contact zuerich@digicomp.ch

Zurich Development Center

Download: Jonathan Lewis in Zürich


Aktueller Newsletter:
dNews März - Verschicken Sie einen Schoggigruss zu Ostern

Monatlich informiert - jetzt den Digicomp Newsletter bestellen...

Kursberatung: 0844 844 822; Mo-Fr 07:30 bis 18:00 Uhr
© Digicomp Academy | Legal | Webmaster | Kontakt | myDIGICOMP