DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Threaded View

  1. #1
    Join Date
    Dec 2001
    Baltimore, MD

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

    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 on windows 2000 Advanced

    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?
    Last edited by Ablakios; 09-07-2003 at 09: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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.