DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: daily routine work

Hybrid View

  1. #1
    Join Date
    Apr 2008
    Posts
    59

    daily routine work

    hi, greetings everybody,

    i'm new to this DBA field, so i may sound childish when i ask this question. What is the daily work of a DBA? What is the daily routine work of an Oracle DBA? i hope many DBA gurus would share their experience. Thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    to make sure their databases are available, reliable, performant and recoverable

    what that involves depends on company to company and app to app

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I think if you're doing the same thing every day, there's a big problem. Who wants to spend their life checking log files and running the same old scripts on the database? If you end up doing something more than three times, automate it. I think the last time I looked at an alert.log was three years ago. I automated the process so when something of interest pops up, I get an alert. I have a script that watches free space in the database and knows when and where to add a datafile should the need arise.

    Your worth as a DBA increases when you can solve problems, not check items off a list.

    YMMV
    Jeff Hunter

  4. #4
    Join Date
    Apr 2008
    Posts
    59
    wow.. u r really a super genius guru... if u don't mind can u pls tel me the script wat u r usin for checkin the freespace? thanks in advance

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    I read my emails, monitor databases usually through
    email, write bash scripts to do the work, play Dungeon
    Crawl and write snarky posts on online forums.

  6. #6
    Join Date
    Apr 2008
    Posts
    59
    thanx for ur replies, how we could find our databases are performant??

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    are your users complaining?

  8. #8
    Join Date
    Apr 2008
    Posts
    59
    not complainin abt tat, inorder to know whether ther is any slight degradation in the performance wat we can do? a pro active method i'm askin guru... thanks in advance

  9. #9
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by GladiatoR
    not complainin abt tat, inorder to know whether ther is any slight degradation in the performance wat we can do?
    First thing to do is to define what's acceptable and what's not acceptable otherwise how would you know there is any degradation?

    Set performance baselines for the most critical queries and processes; if possible negotiate performance SLAs with Business then keep the database performing in between the acceptable boundaries.
    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.

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    when your users start complaining things are different

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