Problem with DBMS_STATS
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Problem with DBMS_STATS

  1. #1
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36

    Question Problem with DBMS_STATS

    Hi Oracle Gurus,
    Whenever I run dbms_stats.gather_table_stats('',''); for a particular table in my database I get the following error.
    ERROR at line 1:
    ORA-01114: IO error writing block to file %s (block # %s)
    and get disconnected from oracle.

    I have checked DBA_TABLES and other details about the table but I am not finding anything unsual about this particular table.
    The same works fine with the other tables in the same schema.
    The oracle version is 9.2.0.4 on sun 2.8.
    If anybody has come across the following problem please help me regarding this.
    Thanks

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Check your alert log files. Some good info must be there.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36

    Unhappy No Info in alert log

    Hi,
    The strangest thing is that there is no new alert log entry, I have tried to run the same a few time, got error every time but no entry in alert log.
    Please look into this matter.
    Thanks

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    What is the last date of the alert log entry..? No new entries..? What is the size of the alert log file?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Also check the physical disk space available where the datafile (tablespaces/datafiles associated with STATSPACK )located.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36

    Unhappy Alls well with database

    There is no problem of free space in the tablespaces and no disk space issues. There is only log switch entries in the alert.log file no unsual entries. Has it to do anything with TEMP tablespace, I am havin locally managed tablespace for temp.
    Even tables which are bigger than this table are getting analyzed without any error. Can this be problem with the particular table. Where can I find if it is so. The status of the table is valid.
    What type of object related errors can cause such error. I could not find any related doc on metalink too.

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Check the datafile or tablespace status. All the datafiles are online?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  8. #8
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36

    Unhappy Once again all's well

    All's well with v$tablesspace, v$backup, v$recover_file, dba_tablespaces, dba_free_space, dba_data_files.

  9. #9
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    metalink has some interesting information on it - I suggest you have a look in there.

  10. #10
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36

    Smile Pls tell me the docid

    Hi,
    Can you please let me know the docid or url for the particular information on metalink. I tried searching a lot of documents on metalink but did not find any relavent information.
    Thanks

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