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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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; ; ; [EMAIL PROTECTED] > > 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" <[EMAIL PROTECTED]> > > 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" <[EMAIL PROTECTED]> > > > 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).