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