+ Reply to Thread + Post New Thread
Results 1 to 5 of 5
  1. 03-02-2009 06:40 PM #1
    Shekhar81's Avatar
    Shekhar81
    Shekhar81 is offline Junior Member
    Join Date
    24 Nov 2008
    Posts
    16
    Say Thanks
    0
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Question oracle update statistics

    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
    Reply With Quote Reply With Quote  
  2.    Club-Oracle Complementary E-Books and Magazines
    Get your free Complementary Copy of Oracle Magazine

    You can also browse the Free Magazines and E-Books section to see the complete list of free magazines, e-books and Whitepapers.
  3. 03-03-2009 04:28 AM #2
    simply_dba's Avatar
    simply_dba
    simply_dba is offline Forum Advisor
    Join Date
    13 Oct 2008
    Location
    Kolkata, India
    Posts
    95
    Say Thanks
    1
    Thanked 5 Times in 5 Posts
    Documents
    0
    Uploads
    0

    Default Re: oracle update statistics

    Read this

    Gather Schema Statistics

    and this

    http://www.oracle-base.com/articles/...ository10g.php
    Some of the world's greatest feats were accomplished by people not smart enough to know they were impossible.
    Reply With Quote Reply With Quote  
  4. 03-03-2009 05:22 AM #3
    UnixGuru's Avatar
    UnixGuru
    UnixGuru is offline Junior Member
    Join Date
    08 Dec 2008
    Posts
    22
    Say Thanks
    0
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Default Re: oracle update statistics

    The complete manual is here

    http://download.oracle.com/docs/cd/B...19/d_stats.htm

    Take particular note of the gather stats procedures. But since you are on 10g, there should already be a job setup to gather statistics.
    Reply With Quote Reply With Quote  
  5. 03-05-2009 06:48 PM #4
    Shekhar81's Avatar
    Shekhar81
    Shekhar81 is offline Junior Member
    Join Date
    24 Nov 2008
    Posts
    16
    Say Thanks
    0
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Default Re: oracle update statistics

    hi guys thanks for the links. i worked it out
    Reply With Quote Reply With Quote  
  6. 03-05-2010 05:25 AM #5
    sodese's Avatar
    sodese
    sodese is offline Junior Member
    Join Date
    02 Mar 2010
    Posts
    1
    Say Thanks
    0
    Thanked 0 Times in 0 Posts
    Documents
    0
    Uploads
    0

    Default Re: oracle update statistics

    sounds good to me
    If you are studying for your microsoft practice exams you are probably looking for some no-hassle, reliable practice questions. The ccna voice training and certification are for people early in their VoIP careers. mcitp training that will teach you everything there is about a specific MCITP.
    Reply With Quote Reply With Quote  
« Two WebCache refering to One Portal | configure EM on second node. »

Similar Threads

  1. how to update columns in different tables
    By Syed Akbar Ali in forum SQL PL/SQL
    Replies: 3
    Last Post: 03-05-2009, 09:28 AM
  2. DBMS_STATS command is taking 2 days of time to UPDATE Statistics of ORACLE DATABASE
    By srinu_hp in forum Server Administration and Options
    Replies: 4
    Last Post: 01-15-2009, 12:17 PM
  3. Project SLG Stats Update!
    By Sadik in forum Announcements
    Replies: 23
    Last Post: 11-06-2008, 12:09 PM

Tags for this Thread