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

Report message to a moderator

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: 26766
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.

Report message to a moderator

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 " ?

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 744
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.

Report message to a moderator

Previous Topic: reload of statements in library cache
Next Topic: is there any need of rebuild pk index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 16:38:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.