Writing Optimal SQL & Troubleshooting & Tuning with Jonathan Lewis

Jan. 12, 2011 - PRLog -- 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.

Frequently Occuring Problems - Some of the most commonly occuring 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.

Quick Fixes - Methods, workaround and dirty tricks for dealing with classic performance problems when the system is in production. There really aren't quick fixes that can be applied across the board - each one needs careful examination of costs, risk and benefits. In this sesion we consider some of the options that are most likely to be worthwhile.

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 sesion will describe the views that are most commomly of use and explain the meaning of some of the most obscurely named but potentially useful items.

Attendance cost: 40.100,00 RSD

Event Organizer: Oracle University

Get more info and register online at http://itevent.net/writing-optimal-sql-troubleshooting-tu...

# # #

At ITEVENT.NET we collect events provided by global corporations and independent consultants from IT, telecom, web and other technology and computer related industries. For more IT events, training courses and conferences please visit http://itevent.net.