Simple & important Q
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Simple & important Q

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    Simple & important Q

    What is the most important thing you look at on a production database? Most important thing in your real life exoerience.
    An ounce of prevention is worth a pound of cure

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    performance and stability

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    A solid and tested backup and recovery plan.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  4. #4
    Join Date
    Nov 2000
    Posts
    416
    And if you think Performance and Stability then what's the most important elements you will look for this objective? How do you implement the perfomance and stabilty mesures?
    An ounce of prevention is worth a pound of cure

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by slimdave
    A solid and tested backup and recovery plan.
    Yes !!
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    How abt a solid backup/recovery & optimal performance..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Nov 2000
    Posts
    416
    General answers!! Let's say I am your tough boss and you claim that Prod DB is in optimal performance and rock solid. Then I ask you please proof me? What is the measures and benchmark you have? And the boss also told you that "But we still get complain from clients"
    How do you hard convince him?
    An ounce of prevention is worth a pound of cure

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by farrokhp
    General answers!! Let's say I am your tough boss and you claim that Prod DB is in optimal performance and rock solid. Then I ask you please proof me? What is the measures and benchmark you have?

    This depends on your SLA and what response times you establish. If you establish that screen X has to come up in sub-second time, then use screen X. If report Y has to be done in N minutes, time report Y.

    And the boss also told you that "But we still get complain from clients"
    How do you hard convince him?
    Obviously you're not meeting your SLA requirements. How can you convice someone that your database is performing fine if your users complain?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by farrokhp
    "But we still get complain from clients"
    Instead of trying to find out a general answer, work on spceific complaints first.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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