Oracle: ORA-01652: unable to extend temp segment by 256 in ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Oracle: ORA-01652: unable to extend temp segment by 256 in ...

Threaded View

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Oracle: ORA-01652: unable to extend temp segment by 256 in ...

    Hi,
    Users are getting the following error msg.
    Oracle: ORA-01652: unable to extend temp segment by 256 in tablespace TEMP1...

    We have a reporting application that is accessed by 3000 users.

    Because of that I have created a dedicated TEMP1 tablespace just for the application and another tablespace TEMP for the users.

    I received ORA-01652 and I have added datafiles to both tablespaces.
    TEMP1 is now up to 8GB
    TEMP is now 7 GB.
    I also increased the SORT_ARAE_SIZE and SORT_AREA_RETAINED_SIZE to 1048576 and keep coalescing both tablespaces. Their pctincrease is set to 0.and I am STILL
    GETTING ORA-01652.

    Those tablespace are DMTT and we running
    Oracle 8.1.7.4 on windows 2000 Advanced
    server.

    I think 15GB for total temp tablespace is
    way too Big and I feel that I just can't keep adding and adding datafiles. Is there anything you can advise me to do?
    Thanks
    Last edited by Ablakios; 09-07-2003 at 10:59 PM.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width