Fwd: Re: Tempfile weirdness
funny how my previous email seems to have been truncated where I put three dots [ie , .] to signifiy 3 lines. Resend : For a critical database where I want to be SURE that the file system has enough space for the TempFile, I run a large SELECT * FROM DBA_SOURCE UNION SELECT * FROM DBA_SOURCE UNION a dot here. another dot here. and a third dot here, signifiying 3 lines. immediately after I startup the Instance [fortunately, the instance startup is supposed to be only once in 1 or 2 years but has practically been once in 3 months]. Hemant At 01:54 PM 17-09-03 -0800, you 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). Date: Thu, 18 Sep 2003 08:34:46 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: Hemant K Chitale [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California For a critical database where I want to be SURE that the file system has enough space for the TempFile, I run a large SELECT * FROM DBA_SOURCE UNION SELECT * FROM DBA_SOURCE UNION Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
Re: Re: Tempfile weirdness
Hi! Try with 2 dots, you might get the same behviour. Or put a space before every dot. Some old unix mailers considered dot in beginning of the line as end of mail... Tanel. - Original Message - From: Hemant K Chitale To: Multiple recipients of list ORACLE-L Sent: Friday, September 19, 2003 6:24 PM Subject: Fwd: Re: Tempfile weirdness funny how my previous email seems to have been truncated where I put three dots [ie , "."] tosignifiy 3 lines.Resend :For a critical database where I want to be SURE that the file system has enough space for theTempFile, I run a largeSELECT * FROM DBA_SOURCE UNIONSELECT * FROM DBA_SOURCEUNIONa dot here.another dot here.and a third dot here, signifiying 3 lines.immediately after I startup the Instance [fortunately, the instance startup is supposed to beonly once in 1 or 2 years but has practically been once in 3 months].HemantAt 01:54 PM 17-09-03 -0800, you wrote:Any comments on the following??When creating index, gotORA-00603: ORACLE server session terminated by fatal errorapparently caused byksedmp: internal or fatal errorORA-01114: IO error writing block to file 121 (block # 149)ORA-27063: skgfospo: number of bytes read/written is incorrectAdditional information: 16384Additional information: 49152which I determined was caused by attempted write to temp tablespace using atempfile. The tablespace was dropped and recreated, and all was well again.What I think MIGHT have happened is the tablespace created weeks ago, butnot used. So it didn't grab any actual storage. In the mean time, some ofthe storage might have been used by something else, but storage wasreleased. Now tempfile goes to grab some space, but filesystem is allscrewed 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 justsomething else to go wrong and make life a bitch?Note that the index create blew up immediately, so the original tempfilenever grabbed any space.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Stephen LeeINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Date: Thu, 18 Sep 2003 08:34:46 -0800To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]X-Comment: Oracle RDBMS Community ForumX-Sender: Hemant K Chitale [EMAIL PROTECTED]Sender: [EMAIL PROTECTED]Reply-To: [EMAIL PROTECTED]Organization: Fat City Network Services, San Diego, CaliforniaFor a critical database where I want to be SURE that the file system has enough space for theTempFile, I run a largeSELECT * FROM DBA_SOURCEUNIONSELECT * FROM DBA_SOURCEUNION Hemant K ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
Re: Tempfile weirdness
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).
OT: Tempfile weirdness
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
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).
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: [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
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 subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnston, Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Tempfile weirdness
For a critical database where I want to be SURE that the file system has enough space for the TempFile, I run a large SELECT * FROM DBA_SOURCE UNION SELECT * FROM DBA_SOURCE UNION
Tempfile weirdness
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).
Re: Tempfile weirdness
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).