DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Problem with DBMS_STATS

  1. #11
    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

  2. #12
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    You've probably read this one if you've searched Metalink, but in case you havent it sounds a lot like your problem i.e. diconnects you and no msgs in alert log etc:
    http://metalink.oracle.com/metalink/..._id=380583.995

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

    Unhappy Analyze also gives the same error

    Hi,
    The docs talks abt bug in 9i but i am already on the higher release than the mentioned patch set. New finding is that the analyze table compute statistics also give the same error. But the file id mentioned with the 01114 error does not exist, how can I find error block without the right file id. Has anybody ever faced a problem of false file id with ora-01114.
    Thanks

  4. #14
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Corrupt Blocks in that tab?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  5. #15
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36

    Unhappy dbv gives no errors

    Hi,
    But dbv does not identify any such block. How to get rid of this problem.
    Thanks

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

    Thumbs up Problem Solved

    Hi,
    The problem was with the Temp datafile. There was some OS corruption on it. So whenever the analyze used to use the tempfile extensively, it would abend. As the tablespace is locally managed we do not get proper info about the problem.
    Thanks to all for the support.

  7. #17
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Apun

    How did you zero down on the temp datafile ?what made you to look into the temp is the problem..

    regards
    Hrishy

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

    Thumbs up How did I find the problem

    Hi,
    Actually analyze talked about a file id which does not exist.
    I read a note on metaink, which indicated that if you are using locally managed tablespace, and the total no. of other datafiles are less than 100, the temp file id will start from 100. SO in my case the file id was 102, so I narrowed down to the tempfile3. I offlined it and then ran the same analyze it worked perfectly.
    It took me a lot of time to find the right doc in metalink.
    Some times the most unexpected ones help u out.
    Thanks to all

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