1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

oracle update statistics

Discussion in 'Server Administration and Options' started by Shekhar81, Mar 2, 2009.

  1. Shekhar81

    Shekhar81 Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    Hi everyone again,

    I am looking for some short document for a oracle update statistics guide for 10g

    The oracle server that I am currently working on, I have copied to another server. On this new server we are using the same resources as the original server yet the performance is poor.

    I am looking to update statistics but obviously I donĀ“t want to do it one by one because the number of tables on production are huge. So can someone tell me how to do a oracle update statistics automatically?

    Thanks everyone for reading
     
  2. simply_dba

    simply_dba Forum Advisor

    Messages:
    95
    Likes Received:
    5
    Trophy Points:
    140
    Location:
    Kolkata, India
  3. UnixGuru

    UnixGuru Active Member

    Messages:
    28
    Likes Received:
    1
    Trophy Points:
    90
  4. Shekhar81

    Shekhar81 Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    hi guys thanks for the links. i worked it out
     
  5. sodese

    sodese Guest

    sounds good to me