Re: OT: Tempfile weirdness

Aha, I found it in OP :)

"Is this another one of those spiffy cool things in Oracle that are just something else to go wrong and make life a bitch?"

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, September 18, 2003 4:39 PM

> Yeah, I got that too.. I did not have in my post any of those words you
mentioned.
>
> - Kirti
>
> --- Tanel Poder <tanel.poder.003_at_mail.ee> wrote:
> > Heh, look what happens if you try to help someone ;)
> > (an automatic reply to my message)
> >
> > -------
> > Trend SMEX Content Filter has detected sensitive content.
> >
> > Place = Multiple recipients of list ORACLE-L; ; ; ORACLE-L_at_fatcity.com
> > Sender = Tanel Poder
> > Subject = Re: Tempfile weirdness
> > Delivery Time = September 18, 2003 (Thursday) 05:43:08
> > Policy = Sexual Discrimination
> > Action on this mail = Quarantine message
> >
> > Warning message from administrator:
> > Notice: A message you sent appears to have violated GE Financial
Assurance
> > email policies for inappropriate language or content and may not have
been
> > received by the recipient.
> > ------
> >
> > Where the heck was the sexual discrimination part in my post? The "bad
> > sectors" part or perhaps "hardware errors?"
> >
> > :)
> > Tanel.
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, September 18, 2003 1:29 PM
> >
> >
> > > It also can be caused by bad sectors or other hardware errors, but I'd
bet
> > > on sparse file problem as you described.
> > > When I create temp tablespaces, I either copy the tempfile into
another
> > > filename and then rename to original using cp, that way the file isn't
> > > sparse anymore, thus no problems using it. Or another way is to create
a
> > > regular tablespace with a datafile first, then drop the tablespace &
then
> > > create temp tablespace reusing this datafile. That way can be handy
when
> > you
> > > don't have shell access for some reason.
> > >
> > > Btw, in most unixes I've worked with, you can see the real size of a
> > sparse
> > > file using ls -ls (in file system blocks).
> > >
> > > Tanel.
> > >
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Thursday, September 18, 2003 2:04 AM
> > >
> > >
> > > > We also ran into the IO error situation on a few of our 9i R2
databases
> > > using TEMPfiles.
> > > > DBAs forgot that the file system contained those tempfiles and
created
> > > other datafiles on those.
> > > > We are now considering using dedicated file system naming convention
> > that
> > > will hold TEMPfiles. We
> > > > already have /u888, and /u999 for dump dirs and archive logs
> > respectively.
> > > Now /u777 for tempfiles
> > > > is under review.
> > > >
> > > > - Kirti
> > > >
> > > >
> > > > --- Stephen Lee <Stephen.Lee_at_DTAG.Com> wrote:
> > > > >
> > > > > 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 and make life a bitch?
> > > > >
> > > > > Note that the index create blew up immediately, so the original
> > tempfile
> > > > > never grabbed any space.
> > > > > --
> > > > >
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kirtikumar Deshpande
> INET: kirtikumar_deshpande_at_yahoo.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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).