Collecting Oracle metrics
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Collecting Oracle metrics

  1. #1
    Join Date
    Mar 2001
    Posts
    149

    Collecting Oracle metrics

    Hi there, I'm a newbie and I've been given a task to collect meaningful Oracle metrics (capacity, uptime, etc) and provide these to my supervisor. Can you please let me know if there is any website/scripts that I can use to find out the metrics? thx in advance!!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    statspack

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Statspack. Great place to start.

    May I suggest you also get Tom Kytes' "Effective Oracle by Design". It'll really help you understand what the numbers mean.

    Chapter 4 is probably where you'll want to focus.

    Here's the table of contents.
    1: The Right Approach to Building Applications
    2: Your Performance Toolkit
    3: Architectural Decisions
    4: Effective Administration
    5: Statement Processing
    6: Getting the Most Out of the Cost-Based Optimizer
    7: Effective Schema Design
    8: Effective SQL
    9: Effective PL/SQL Programming
    10: So, You Had an Accident
    Appendix A: Setting Up and Some Scripts

  4. #4
    Join Date
    May 2002
    Location
    Western Australia
    Posts
    233
    Originally posted by KenEwald
    Statspack. Great place to start.

    May I suggest you also get Tom Kytes' "Effective Oracle by Design". It'll really help you understand what the numbers mean.

    * snip *
    If a newbie should have one piece of advice it has to be "Read the concepts document and buy this book!". The 9i OCP program would do well consider evidence of reading Tom's book rather than some dozy requirement to sit a class!

    Cheers

    Nick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width