how to analyz the Database Performance using UTLBSTAT and UTLESTAT.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to analyz the Database Performance using UTLBSTAT and UTLESTAT.

  1. #1
    Join Date
    Jul 2002
    Posts
    42
    Hi,
    I have taken the report by running the UTLBSTAT/UTLESTAT scripts. Now I wanted to compare my statistics . Is there any document to identify the bottlenects from the resport. or URLs
    thanks lot
    Oracle

  2. #2
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    816 and above u can use the statspack.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  3. #3
    Join Date
    Jul 2002
    Posts
    42
    Thanks taryy.
    MY oracle db is 8.15 running windows NT.
    also want to know the time difference of running the UTLBSTAT and UTLESTAT packages.
    Oracle

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    There's no harad and fast rule, choose the busiest time of database engagement and keep a few hours in between.
    Well you can keep it for days as well.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Check http://www.oraperf.com. You could upload the report.txt file, and get their recommendations. After analyze the recommendartions ....

    Cheers

    Angel

  6. #6
    Join Date
    Jul 2002
    Posts
    42
    thanks tarry.
    Oracle

  7. #7
    Join Date
    Jul 2002
    Posts
    42
    thanks lot aarro
    Oracle

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