IOUG Live! 2004--Tuesday, April 20, 2004

by Stephen Andert


Richmond Shee's presentation "If Your Memory Serves You Right." gave the
audience a better understanding of the activities related to sorting in the
database. He demonstrated how to use events 10032 and 10033 to learn how
sorts are being done. I liked the sliding scale where he showed the fastest
sorts (in memory) all the way to slowest sorts (multi-pass) and for the
one-pass sorts, what the best utilization of memory is to maximize
performance.




Peter Robson discussed data integrity and demonstrated the methodology he
has been a part of to have ongoing monitoring to ensure data and information
about the data (metadata) is complete and accurate. He showed how they have
used this method to produce reports that help to track the "Database Health
Quotient" on a historical basis. This alerts you to new data or structures
that have potential problems for further follow-up.




As I mentioned in another note, this year has sessions starting earlier and
ending later than they have in years past. One of the presentations I am
doing this year started at 4:45 this afternoon and I was concerned with how
many attendees would be there and still relatively conscious at that time in
the afternoon. I had a good turnout and my audience was responsive, alert
and asking some good questions. There have been some people that have
attended conference events in the past and taken advantage of all the
vendor-sponsored entertainment events and social events, reducing or
minimizing their attendance or participation at the educational events.
Conferences were therefore considered by some to be a bonus of sorts and
attendance was allowed as a reward or incentive for selected staff. I think
the IOUG events that I have attended over the past 4 years demonstrate that
the focus of most of the attendees here is the educational benefit rather
than strictly the entertainment events and the t-shirts, pens and other
vendor give-away gifts. Not that most of the people here won't be bringing
home a few vendor souvenirs, but that most people will be bringing home more
knowledge and practical skills than they had when they arrived.




In terms of the education options available here, we have come a long way in
a few years in the world of Oracle tuning is just a few years. Looking over
the presentation titles for this conference, many sessions talk about the
Wait Interface, extended SQL Trace and Event 10046. Several years ago, the
common tuning presentations focused on checklists and ratios. Watching
trends like this at this conference is always interesting and an important
way to stay alert to trends in our industry.



Do you have any thoughts on the most effective tuning methodology?