DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: to all DBAS:Oracle standards ?

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Hello
    I have been given the task of figuring out Oracle standards and i needed some guidance from you all.

    I am looking for a guideline of what type of standards i should have with Oracle. from file system to mountpoints to
    monitoring etc,.

    thanks
    Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What kind of standards? For database installation, you should definitely follow OFA http://technet.oracle.com/docs/produ...tro.htm#10463.

    If you are looking for object naming standards, that is really site dependant.
    Jeff Hunter

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    i am not looking for OFA but basic standards.. analyze table on this day, check for this, mount points should be named after the instance name etc.
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    There is no hard and fast rule on oracle that you have to do things by this way only. As Jeff suggested, OFA is the best bet to undestand how oracle would start placing things be default. To have more idea on the mount points just refer the installation maual for your platform of choice.


    Other than that of backupup, analyzing and etc depends on your shops requirements. There are a number of backup startegies available under technet.oracle.com.

    Good luck

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    i understand that but i need some suggestions as far as what you follow. Oracle should be standard thruout company.l
    "High Salaries = Happiness = Project Success."

  6. #6
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    I can't speak to the rest of your issues, but as far as analyzing tables go...

    Each database will have a different schedule. This is not something that you can create a hard-and-fast rule for, at least not an in-flexible one.

    Something you *might* consider is:

    - A nightly job that analyzes the *extremely* dynamic tables.
    - A weekly job that analyzes the *average* dynamic tables.
    - A monthly job that analyzes all tables.

    Then, you could decide on a database-by-database basis which tables fall into which categories.

    Just a thought,

    - Chris

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    To give you more information, it would be good if you could say what you are looking for. Since your question was wague, it is really hard to speak in each and every prospective point of views. The best way would be, that you tell us what kind of issues that you are looking for and then we can try to come up with exploring the topics.

    Try to disect your issues into multiple parts and ask the questions on them one by one in an orderly manner. That would help you to u.stand each area in detail and you can have it as a reference too.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by jlakhani
    Oracle should be standard thruout company.l
    I disagree. Each and every database has different requirements as to the volume of data, update frequency, time to recover, etc., etc. Without more specifics, the answer is "It Depends."

    In a heavy OLTP shop where a large percentage of the data changes daily, an analyze every night would not be unreasonable. In an OLTP shop where only a small percentage of the data changes on a daily basis, analyzing once a week may be sufficient.

    I prefer that all production OLTP database be backed up at least once a day. DW should be backed up after the data changes.
    Jeff Hunter

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