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).
Received on Thu Sep 18 2003 - 08:39:40 CDT
