+ Reply to Thread
Results 1 to 7 of 7
  1. 07-08-2009 04:47 PM #1
    ocp2b
    ocp2b is offline Member
    Join Date
    Sep 2001
    Posts
    163

    Database staffing ratio

    I apologize if this is the wrong group to put this question.

    I am looking for a formula to calculate the number of DBA's needed to support an Oracle database. Something that I can plug the number of databases we have, the size of the databases and it will calculate the number of DBA's needed to support them.

    Thanks.

    Scott
    Reply With Quote Reply With Quote
  2. 07-08-2009 05:30 PM #2
    PAVB's Avatar
    PAVB
    PAVB is online now Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,492
    No silver bullet.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  3. 07-08-2009 05:32 PM #3
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline mod
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,844
    I would say the Pi/square root of 2.

    Although I guess I would need to know something about the application that uses your database, uptime requirements, complexity of your environment, budget...
    this space intentionally left blank
    Reply With Quote Reply With Quote
  4. 07-08-2009 05:32 PM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    who on earth would have anything like that

    utter craziness
    Reply With Quote Reply With Quote
  5. 07-08-2009 05:43 PM #5
    ocp2b
    ocp2b is offline Member
    Join Date
    Sep 2001
    Posts
    163
    I saw one one time from the Gartner group but I can't seem to find it again. It was pretty slick. You inputted some information such as # of dbs, # of servers, db sizes, etc. and it calculated the number of resources needed to support the databases.
    Reply With Quote Reply With Quote
  6. 07-09-2009 06:31 AM #6
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    size of database is in no way related to how much support is required

    there is no corrolation
    Reply With Quote Reply With Quote
  7. 07-09-2009 09:10 AM #7
    gandolf989's Avatar
    gandolf989
    gandolf989 is offline mod
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,844
    Quote Originally Posted by davey23uk View Post
    who on earth would have anything like that

    utter craziness
    Both pi and the square root of two are irrational numbers.
    Therefore the answer is an irrational number between 1 and 2.
    this space intentionally left blank
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width