standards for Oracle database utilisation levels
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: standards for Oracle database utilisation levels

  1. #1
    Join Date
    Aug 2005
    Posts
    17

    standards for Oracle database utilisation levels

    Hi,

    Can we get an industry or published standards for Oracle database utilisation levels. We are looking to compare against things such as:
    1. cpu utilisation
    2. disk utilisation - % of tablespace allocated v's tablespace used
    3. disk utilisation - % of total disk allocated v's total disk used (for the datafiles, archivelog, etc. to use)
    4. number of databases managed per DBA (ie. 1 DBA manages 10 databases).

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    You aim is to get 100% cpu utilisation with no-one waiting for anything. Then you chose the perfect hardware for your project

    I wouldnt want my disks going above 80%

    number of databases - there is no standard, you look after what you have. Will find a range of answers here

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Quote Originally Posted by dilipbabu_184
    4. number of databases managed per DBA (ie. 1 DBA manages 10 databases).
    How complex and how critical is the database? How many application runs in the database? A database does not necessary house one application only

  4. #4
    Join Date
    Aug 2005
    Posts
    17
    Thanks Dave

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    With regard to point 3, what you may find to be of more importance is the speed of the disk arrays, rather then their capacity. The ratio of storage space to speed on disks has been growing so much that you can easily be using only 30% of your available disk Gb and find yourself in trouble in terms of Mb/sec.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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