IOUGA Live 2001

1
IOUG-A Live! 2001

• Top Ten Things I Learned at
• IOUG-A Live! 2001

2
What Is IOUG-A Live?

• Technical conference?
• Educational seminars?
• Time off from work?

3
What is the value in IOUG-A Live?

• Highly focused technical seminars and lessons
  from experts in the field
• Broad coverage of the most current issues facing
  Oracle professionals
• Being out of the office for a week(what do you
  mean the pager doesnt work there?)

4
Top Ten List

• Here are the top ten things that I learned at
  IOUG-A Live!

5
10 - All Roads Lead to Disney!

• You cant miss it and you cant get lost
• The family has something to do while you wallow
  in geekdom.

6
9 - Dancing with EXPLAIN PLAN is easy

• When you know the steps, that is
• Many sessions dealt with reading the report that
  EXPLAIN PLAN generates
• www.elementkjournals.com/dbm/9704/dbm9741.htm
• www.dbspecialists.com/4dbas/present.html

7
8 - Java Not just lifeblood

• Several developer sessions and some DBA and data
  warehousing sessions dealt with using Java and
  Java Stored Procedures
• Oracle is investing much into the Java platform
• Oracles documentation assumes you are a Java
  guru (I know Im not) and these kinds of sessions
  help.

8
7 - Big Iron Is Coming Back

• The swing is away from Client/Server and back to
  centralized computing
• Evidence
• Oracle 9i Real Application Clusters (Parallel
  Server)
• PowerUnit Pricing
• Oracle on mainframes

9
6 - How to save 1 Billion

• Consolidation
• Centralized management of software and standards
  to a single set of machines

10
5 - Gas is cheaper in Florida

• For now.

11
4 - Oracle 9i will do away with DBAs

• Yeah, right! But it will make being a DBA a bit
  easier
• Expert systems (if properly configured) will
  handle some of the more mundane tasks
• DBAs will still need to exist because users will
  still do the unexpected

12
3 - The Big Bash

• One Part Geek
• One Part Alcohol
• One Part Survivor (TM)
• THE BIG BASH

13
2 - Cache Hit Ratios are for Losers

• Ratios cant tell you everything
• Relying on them will cost money
• The Wait Interface is better
• vsystem_event, vsession_event, vsession_wait,
  vsesstat
• These four views allow you to quickly assess the
  performance problem

14
Cache Hit Ratios are for Losers (cont.)

• Its reliable
• Its repeatable
• Its accurate
• Its effective
• www.miaracleas.dk/uk/ToolLinks.html
• www.hotsos.com
• www.google.com - Search for Oracle Tuning

15
1 - Real Power of Experience

• The Power of Real Experience was an apt name
  for the conference
• Experts were willing to share before, during, and
  after sessions
• You can learn a lot and have fun doing it.

16
Next Year

• April 14-18
• San Diego, CA

17
Thank You