| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> OT: Tempfile weirdness
Heh, look what happens if you try to help someone ;)
(an automatic reply to my message)
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.
> 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.
> > > --
> > > 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).
> >
> >
> > __________________________________
> > 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).
>
-- 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).Received on Thu Sep 18 2003 - 05:54:39 CDT
 |
 |