Hi! I have a suggestion as well:
Tempfiles are sparse files in unix, that is you can use alter tablespace command to add or resize the files even to 100G if you want, but they don't actually use much space on disk. When you start writing to this file, OS tries to allocate more real space to it and will fail if file system is full (depending on OS and your quota + rights you might actually see some free space, but it's unusable). You can see real size of a file in file system blocks using ls -ls (at least in Solaris & HP-UX it works...) Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, July 27, 2003 10:44 AM > Check the block sizes. That part of the argument might still stand. > > On 2003.07.27 02:24, Saira Somani wrote: > > We are using 32-bit on 5L. I don't think Oracle 8.1.7 > > is compatible with 64-bit AIX kernel. > > > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > > Your 1652 error means the following: > > > > > > 01652, 00000, "unable to extend temp segment by %s > > > in tablespace %s" > > > // *Cause: Failed to allocate an extent for temp > > > segment in tablespace. > > > // *Action: Use ALTER TABLESPACE ADD DATAFILE > > > statement to add one or more > > > // files to the tablespace indicated. > > > > > > If everything else is the same, I would say that the > > > new OS is using a > > > different OS filesystem block size. That would mess > > > up all your file sizes, > > > allocations and alike. You are probably using 64 bit > > > JFS on 5L, straight up > > > from 32-bit 4.3.3? > > > > > > > > > On 2003.07.27 00:39, Saira Somani wrote: > > > > Hi Gurus, > > > > > > > > After upgrading the OS from AIX 4.3.3 to 5.1, our > > > > Oracle 8i instance is dishing out plenty of > > > ORA-1652 > > > > which means that our application cannot commit any > > > > transactions (or so I am finding in my tests). > > > > > > > > Help. The warehouse needs to be in production > > > > tomorrow 8AM! > > > > > > > > Thanks, > > > > Saira > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.net > > > > -- > > > > Author: Saira Somani > > > > 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). > > > > > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.net > > > -- > > > Author: Mladen Gogala > > > 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: Saira Somani > > 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). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > 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).
