Home » RDBMS Server » Performance Tuning » ORA-1652: unable to extend temp (Oracle 10g R2 ,AIX)
ORA-1652: unable to extend temp [message #408157] Sun, 14 June 2009 23:56 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
hi,

Hi , i have found below error in alert log .

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


I have generated awr report to find the detail of failed session and the the session that was using most of TEMP .But i didnt find any useful info from AWR. Can someone guide me what to be checked in AWR to get these details ? Thanks
Re: ORA-1652: unable to extend temp [message #408158 is a reply to message #408157] Mon, 15 June 2009 00:01 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
>Can someone guide me what to be checked in AWR to get these details ?
Alternatively, throw hardware at the problem & double or triple the TEMP size.
Re: ORA-1652: unable to extend temp [message #408166 is a reply to message #408157] Mon, 15 June 2009 00:20 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Swan, thanks
but that do you mean by "Alternatively, throw hardware at the problem " ?
Re: ORA-1652: unable to extend temp [message #408168 is a reply to message #408166] Mon, 15 June 2009 00:25 Go to previous messageGo to next message
BlackSwan
Messages: 25040
Registered: January 2009
Location: SoCal
Senior Member
gkrishn wrote on Sun, 14 June 2009 22:20
Swan, thanks
but that do you mean by "Alternatively, throw hardware at the problem " ?


double or triple the TEMP size.
Re: ORA-1652: unable to extend temp [message #408578 is a reply to message #408168] Tue, 16 June 2009 23:32 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
In AIX, I guess your Database used raw device, not file system, don't I?

You can double, triple or recreate it.
Previous Topic: reload of statements in library cache
Next Topic: is there any need of rebuild pk index
Goto Forum:
  


Current Time: Tue Dec 06 08:38:00 CST 2016

Total time taken to generate the page: 0.13340 seconds