IOUG-A Live! 2002 - Day 4 (Wednesday)
by Stephen Andert
Gaja's presentation Proactive Oracle Storage Management (POSM) - A Method To Predictable System Performance has been called possum by some, but this was no varmint of a presentation! I would like to have been joined by some systems administration folks for this session. I think the knowledge contained in this presentation will help systems administrators to better understand the specific challenges in dealing with Oracle databases.
He said to make sure file system (or operating system) block size same as db block size and referred to a replacement of the 80-20 Rule. The 90-10 I/O Rule for Oracle is that less than 10% of the objects (seqments) in the db causes 90% of the I/O bottlenecks. This explains why Gaja repeatedly said that if we only remembered one thing from this session it was that we need to deal with I/O contention at the object level, NOT AT THE FILE LEVEL. If you start moving aroung hot files, you could end up playinq "musical chairs" with your data files with no improvement in performance.
Kirtikumar Deshpande's presentation Oracle Wait Events In A Nutshell gave a solid base on the Wait Interface. For people new to Wait Events, he covered why and how to use them to diagnose performance problems. This was a great presentation that gave a great overview of this important new strategy for tuning.
Another presentation later in the day really should have been named Oracle Wait Events part II as it was the logical continuation of Kirti's presentation. Richmond Shee presented his paper Got Waits? A Wait-Based Approach To Tuning and Optimization where he showed how to use the wait information Kirti introduced to solve the underlying problem. This presentation gave a overview on what causes specific wait events.
Bruce McCartney presented Introduction to ORATCL. TCL stands for Tool Command Language and ORATCL is an extension to TCL. It is a command language that can perform some of the same functions as shell, Perl and Python. Some of the benefits of using TCL instead of these alternatives are:
-Portable across operating systems
-Robust (includes error handling)
-Flexible and extensible
Bruce was convincing enough that I started thinking about some tasks that I could use this for to help make some processes more flexible and simple.
Tim Quinlan's presentation Advanced SQL Tips for Developers and DBA's was so popular earlier this week, that it was added to the schedule again today. Tim covered a lot of material on everything DBMS_PROFILER to help tuning to new 9i features like median and merge. This was a great presentation that I hope to glean information from to share with the developers that work with.
Talking with people between sessions is always a great part of conferences. Several conversations I have had this week have ended up with me pulling my PDA out to jot down someone's e-mail address to ask them for more information or to send them information that I have at home. This user group approach to information sharing is part of what makes our community so strong.
Tomorrow is the last day of the conference and on Friday I'll post my perspectives in a conference summary.