ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP1

  1. #1
    Join Date
    Feb 2002
    Posts
    12

    ORA-1652: unable to extend temp segment by 1280 in tablespace TEMP1

    Hi All,

    we are facing severe problem with temp tablesapce.. once we got the error we adder more space to temptablespace, and bounced the database also. there is no impact on this. again we droped the temp tablespace and recreated the temptablespace... no change..
    we added more RAM to the server also..we are getting the very slow performance problem.. please suggest how to proceed
    Bhanu Msc

  2. #2
    Join Date
    Sep 2005
    Posts
    278
    Show us the queries which is utilize so much temporary tablespace,
    better u tune those queries rather than going on increasing the RAM

  3. #3
    Join Date
    Mar 2002
    Posts
    534
    would be interesting to get some more details about your application, system, DB and hardware.

    also it may help to see what kind of query generates this error.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    ==
    we added more RAM to the server also..we are getting the very slow performance problem..
    ==

    I think you did not identify the root cause of the problem. Just throwing more hardware will not solve your problem.
    My guess is your system is doing more hash join or parallel processing.

    Tamil

  5. #5
    Join Date
    Sep 2005
    Location
    Hyderabad
    Posts
    12
    Check the following to tune db

    v$sqlarea
    v$filestat
    v$system_event

    Also genarate a statspack for 1hr to get a fair idea.
    ______
    Sekhar

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by tamilselvan
    Just throwing more hardware will not solve your problem.
    or even make it worse.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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