Re: DBMS_STATS and CBO

Hi,

    I have hit similiar situation in my datawarehouse server. As temp file are sparse, it did not allocate the actual space when it was created.

    But as you really begin to sort and the filesystem is full , you can get this error. I offlined that tempfile and add another tempfile in another filesystem and everything is ok.

Regards
zhu chao
msn:chao_ping_at_163.com
www.cnoug.org
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, September 18, 2003 11:49 PM

> (Resending)
>
> Any comments on the following??
>
> When creating index, got
> ORA-00603: ORACLE server session terminated by fatal error
>
> apparently caused by
>
> ksedmp: internal or fatal error
> ORA-01114: IO error writing block to file 121 (block # 149)
> ORA-27063: skgfospo: number of bytes read/written is incorrect
> Additional information: 16384
> Additional information: 49152
>
> which I determined was caused by attempted write to temp tablespace using
a
> tempfile. The tablespace was dropped and recreated, and all was well
again.
>
> What I think MIGHT have happened is the tablespace created weeks ago, but
> not used. So it didn't grab any actual storage. In the mean time, some
of
> the storage might have been used by something else, but storage was
> released. Now tempfile goes to grab some space, but filesystem is all
> screwed up about what storage the tempfile should be grabbing.
>
> Does this sound plausible?
> Is there something else going on here?
> Is this another one of those spiffy cool things in Oracle that are just
> something else to go wrong? There seems to be no way of creating a LMT
> tempfile so that it pre-grabs the disk space.
>
> Note that the index create blew up immediately, so the original tempfile
> never grabbed any space. So, I think I can say that is definitely didn't
> run out of space; but maybe somebody walked across the space the tempfile
> thought it was going to get in the future.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: Stephen.Lee_at_DTAG.Com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: zhu chao
  INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).