Home » RDBMS Server » Performance Tuning » ORA-1652: unable to extend temp segment by 16 in TEMP TS
ORA-1652: unable to extend temp segment by 16 in TEMP TS [message #243695] Fri, 08 June 2007 08:28 Go to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Hi, 
I have following error in my alert log.

ORA-1652: unable to extend temp segment by 16 in tablespace                 TEMP

I can't see what's the sql causing error and we have our TEMP TS is big. This error was at 3 AM so we don't have any idea who was running and which sql. 
Could you please let me know how can i trace which sql cause this error? I have tried to check in user dump.

Thanks. 


Re: ORA-1652: unable to extend temp segment by 16 in TEMP TS [message #243784 is a reply to message #243695] Sat, 09 June 2007 00:19 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Hi,
If you are using oracle 10g, then use EM->performance tab.
Top Sessions tab may be useful for you. This will list you top consumers with various useful informatin like, Total reads, hard parse, soft parse, sorts etc.
Top sql tab may also help you find the problem area.

Regards.
Re: ORA-1652: unable to extend temp segment by 16 in TEMP TS [message #243796 is a reply to message #243695] Sat, 09 June 2007 01:09 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,
Quote:
This error was at 3 AM so we don't have any idea who was running and which sql.


Use STATSPACK report and see what was running at that time.

Brayan.
Re: ORA-1652: unable to extend temp segment by 16 in TEMP TS [message #251177 is a reply to message #243796] Thu, 12 July 2007 10:28 Go to previous message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Thanks.
I have created table and triggerand which will store info whenever it occures.

Thanks,
Previous Topic: execution plan for a stored procedure
Next Topic: Buffer Pool
Goto Forum:
  


Current Time: Sun Dec 04 18:46:20 CST 2016

Total time taken to generate the page: 0.04617 seconds