Home » RDBMS Server » Backup & Recovery » ORA-1688: unable to extend table in SYSAUX tablespace
ORA-1688: unable to extend table in SYSAUX tablespace [message #166969] Mon, 10 April 2006 10:44 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member

I get this errorin my alert log file.

ORA-1688: unable to extend table SYS.WRH$_ACTIVE_SESSION_HISTORY partition WRH$_ACTIVE_216122103_4291 by 64 in tablespace SYSAUX
SYSAUX is new to Oracle10g. Don't have much knowledge on this tablespace.
Any idea why this error comes and what should be looking into.

Thanks in advance
Re: ORA-1688: unable to extend table in SYSAUX tablespace [message #167037 is a reply to message #166969] Mon, 10 April 2006 23:46 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
Connect to your database by sysdba and then run the follow sql:

select a.TABLESPACE_NAME, round(total,1) Total_M, round(free) Free_M, round(100*(1-free/total),1) Usage
from (select TABLESPACE_NAME,sum(BYTES)/(1024*1024) total from dba_data_files group by TABLESPACE_NAME) a
,(select TABLESPACE_NAME,sum(BYTES)/(1024*1024) free from dba_free_space group by TABLESPACE_NAME) b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME(+) order by 4 DESC;

You will get the USAGE information about SYSAUX. If it is full, you can add more data files or enlarge the exist datafiles.

Alex zeng |Skpye me: hans9zeng
Re: ORA-1688: unable to extend table in SYSAUX tablespace [message #167087 is a reply to message #167037] Tue, 11 April 2006 04:58 Go to previous messageGo to next message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member

if you are taking awr snapshots try to change(lower) snapshot retention period

Thanks
Madhu
Re: ORA-1688: unable to extend table in SYSAUX tablespace [message #167141 is a reply to message #166969] Tue, 11 April 2006 09:11 Go to previous messageGo to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member

Thanks for the suggestions.

I did take an immediate action to add datafile when I got this error in order to resolve the problem. At least we had enough storage disk available to add data files.

Madhu, You are correct. We are taking the snapshot. The default period is to retain for 7 days. However this process is in production for more than 6 months. And I had never faced problem.

But came accross this problem just recently. Since the problem is now resolved, I am now investing to find out what could be the possible cause.

I checked the wrh$active_session_history table. Count is 850,000 records which I think is possibly high.
The question is that Can I delete records from this table. Will there be any problem if I do that?
Or is there a better solution to prevent this happening again.

Thanks
Re: ORA-1688: unable to extend table in SYSAUX tablespace [message #171577 is a reply to message #167141] Wed, 10 May 2006 08:01 Go to previous messageGo to next message
migrojas
Messages: 1
Registered: May 2006
Location: Caracas
Junior Member

I have the same problem, every one now how can i do to truncate tables SYS.WRH$%.
I dont have more space in the storage
Re: ORA-1688: unable to extend table in SYSAUX tablespace [message #602602 is a reply to message #166969] Thu, 05 December 2013 22:22 Go to previous messageGo to next message
jedwa@comcast.net
Messages: 2
Registered: December 2013
Location: U.S.A.
Junior Member
You could be facing an Oracle bug. Please read the following, I just dealt with this recently.
http://tinky2jed.wordpress.com/2013/12/05/ora-1688-unable-to-extend-table-sys-wrh_active_session_history/
Re: ORA-1688: unable to extend table in SYSAUX tablespace [message #602607 is a reply to message #602602] Thu, 05 December 2013 22:53 Go to previous messageGo to next message
BlackSwan
Messages: 21975
Registered: January 2009
Senior Member
Welcome to the Forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>You could be facing an Oracle bug. Please read the following,
I doubt that Oracle had an unresolved BUG for the last SEVEN years across multiple major release versions.
(Note date of original post in this thread.)

>I just dealt with this recently.
Are you bragging or complaining?

Re: ORA-1688: unable to extend table in SYSAUX tablespace [message #602616 is a reply to message #602607] Thu, 05 December 2013 23:52 Go to previous message
jedwa@comcast.net
Messages: 2
Registered: December 2013
Location: U.S.A.
Junior Member
I'm trying to help anyone who might find this and has the bug. If they have this bug it is easy to figure out and hopefully this will help them solve it faster. I came across this post when I first hit it, so I'm guessing other people will too.

[Updated on: Thu, 05 December 2013 23:53]

Report message to a moderator

Previous Topic: Incremental backup restoration without archieve log files
Next Topic: Can not recover file
Goto Forum:
  


Current Time: Thu Apr 24 13:13:16 CDT 2014

Total time taken to generate the page: 0.09497 seconds