RE: OT: Tempfile weirdness
Nah... I think it was the... "something else to go wrong and make life a bitch?" In the original post... Looks like the scanner looks at the entire message... Tim -Original Message- Sent: Thursday, September 18, 2003 9:40 AM To: Multiple recipients of list ORACLE-L 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 bxxxh? > > > > > > > > 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 subscri
Re: OT: Tempfile weirdness
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
Re: OT: Tempfile weirdness
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).