RE: Ora 1652

Wow. Once again, Mladen proves to the world (well, this list, anyway) that he has WAY too much time on his hands. :>)

You can tell me all about RAID5, Legato, RMAN, and DLT-whatever. That's yuppie stuff. Try running Oracle on an e-Machine, Redhat 5.2 with 128mb RAM, Apache web server and 15 hosted sites. Takes a REEEALLLLL MAAAANNNNN (or Rachel) to run something like that!!!!

And believe it or not, we're still in business. :>)

:>) :>)

--Walt Weaver
  Bozeman, Montana, USA

P.S. Thanks for posting, Mladen. You haven't been doing enough of it lately. P.P.S I'm in for it now... should've just gone to bed...

-----Original Message-----
From: Gogala, Mladen [mailto:MGogala_at_oxhp.com] Sent: Wednesday, July 19, 2000 6:46 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Ora 1652

Obviously, this error tells you that Oracle cannot extend segment. Oracle can fail to extend a segment only because of the lack of the necessary space in the tablespace. A common wisdom (and OFA, which is anything but the common wisdom)
tells you to separate different object types into the different tablespaces. Tablespace system should be used for DICTIONARY TRANSACTIONS ONLY. If you see somebody to use the tablespace SYSTEM as the temporary tablespace (see CREATE LUSER command options) please fell free to shoot the DBA. It would also
be advisable to put the rollback segments into their separate tablespace and (I know I'm asking too much now!) to separate tables and indexes not only to the
separate disks but to the separate controllers as well. When it comes to the system safety, words like RAID-5, EMC, Legato Networker and DLT7000 robot and RMAN
come into my mind. Running a well designed database with 95% uptime is an expensive proposition.
If you were an internet company, like let's say E-Bay, then you couldn't afford
not to install patches, not to have a hot standby system and not have even a proper backup and keep your systems down for a week, could you?

-----Original Message-----
Sent: Wednesday, July 19, 2000 5:06 PM
To: Multiple recipients of list ORACLE-L

When I checked yesterday's alert logs, I found the following error:

ORA-01652 unable to extend temp segment by (num) in tablespace SYSTEM.

I've forgotten what the actual number was. The recommended action is to add a datafile. However, when I checked the existing datafile, it is less than 50% full, with 20 MB remaining, and 11 MB in the next available extent.

Does anyone have any idea what is causing this? For now, I plan to see if the error occurs again, and then add another datafile if necessary. The error occurred during business hours (ie. when the database was in use) and we also have developers working on an update, although they are supposed to be working on the development database.

Thanks.

• Kristen Cameron Indian and Northern Affairs Canada Yellowknife, NT

-- 
Author: Kristen Cameron
  INET: cameronkgd_at_inac.gc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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