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. > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Stephen Lee > > > 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). > > > > > > __________________________________ > > 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). > -- 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).
