OraFAQ Forum: Performance Tuning » ORA-1652: unable to extend temp segment by 16 in TEMP TS

Home » RDBMS Server » Performance Tuning » ORA-1652: unable to extend temp segment by 16 in TEMP TS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-1652: unable to extend temp segment by 16 in TEMP TS [message #243695]

Fri, 08 June 2007 08:28

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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,

Report message to a moderator

Previous Topic:	execution plan for a stored procedure
Next Topic:	Buffer Pool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 08:11:36 CST 2024