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

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

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

Search Discussions

  • Smith, Ron L. at Jul 19, 2000 at 8:23 pm
    I would guess that a user is defined to the instance with its default and or
    temporary tablespace a "system".

    -----Original Message-----
    From: Kristen Cameron
    Sent: Wednesday, July 19, 2000 4:06 PM
    To: Multiple recipients of list ORACLE-L
    Subject: Ora 1652

    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).
  • Kristen Cameron at Jul 19, 2000 at 10:16 pm
    Yes, that was exactly it. Thank you.

    I seem to be at the stage of learning where I sometimes
    know how to fix an identified problem, but I haven't yet=20
    learned how to identify the problem!

    Kristen
    rlsmith_at_kmg.com 7/19/2000 >>>
    I would guess that a user is defined to the instance with its default and =
    or
    temporary tablespace a "system".

    -----Original Message-----
    Sent: Wednesday, July 19, 2000 4: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. =20

    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

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

    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).
    --=20
    Author: Smith, Ron L.
    INET: rlsmith_at_kmg.com=20

    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).
  • Gogala, Mladen at Jul 19, 2000 at 11:35 pm
    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-----
    From: Kristen Cameron
    Sent: Wednesday, July 19, 2000 5:06 PM
    To: Multiple recipients of list ORACLE-L
    Subject: Ora 1652

    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).
  • Weaver, Walt at Jul 20, 2000 at 3:12 am
    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
    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
  • Gogala, Mladen at Jul 20, 2000 at 2:56 pm
    May I use RH 6.2? I know that this would make things a kind of
    too easy, but I really need glbc 2.1. And another question: is
    Rachel a real man?

    -----Original Message-----
    From: Weaver, Walt
    Sent: Thursday, July 20, 2000 12:24 AM
    To: Multiple recipients of list ORACLE-L
    Subject: 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-----
    Sent: Wednesday, July 19, 2000 6:46 PM
    To: Multiple recipients of list ORACLE-L

    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
    also send the HELP command for other information (like subscribing).
    --
    Author: Weaver, Walt
    INET: wweaver_at_rightnowtech.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
  • Eric D. Pierce at Jul 20, 2000 at 5:42 pm
    On 19 Jul 2000, at 20:24, Weaver, Walt scribbled with alacrity and cogency:

    Date sent: Wed, 19 Jul 2000 20:24:23 -0800
    To: Multiple recipients of list ORACLE-L
    From: "Weaver, Walt"
    Subject: RE: Ora 1652
    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.
    Walt, that is a really robust server, why don't you try saving your
    clients some money by running on something like this:

    Matchbox Web Server:

    http://wearables.stanford.edu/hardware.html

    (joke!)
    Takes a REEEALLLLL MAAAANNNNN (or
    Rachel) to run something like that!!!!

    And believe it or not, we're still in business. :>)
  • Rachel Carmichael at Jul 20, 2000 at 11:54 pm
    Not the last time I looked I wasn't!

    Welcome back Mladen, I've missed the grins from your posts.....
    From: "Gogala, Mladen"
    Reply-To: ORACLE-L_at_fatcity.com
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Ora 1652
    Date: Thu, 20 Jul 2000 08:05:16 -0800

    May I use RH 6.2? I know that this would make things a kind of
    too easy, but I really need glbc 2.1. And another question: is
    Rachel a real man?

    -----Original Message-----
    Sent: Thursday, July 20, 2000 12:24 AM
    To: Multiple recipients of list ORACLE-L


    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-----
    Sent: Wednesday, July 19, 2000 6:46 PM
    To: Multiple recipients of list ORACLE-L


    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
    also send the HELP command for other information (like subscribing).
    --
    Author: Weaver, Walt
    INET: wweaver_at_rightnowtech.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
    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
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 19, '00 at 7:57p
activeJul 20, '00 at 11:54p
posts8
users6
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase