Home » RDBMS Server » Server Administration » ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1' (Oracle 9i)
ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1' [message #352074] Mon, 06 October 2008 00:07 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I am getting the following error in UNDO TABLESPACE
while running our scenario is there any way resolve it

 ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1'
ORA-27059: skgfrsz: could not reduce file size
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk.
ORA-27059: skgfrsz: could not reduce file size
OSD-04005: SetFilePointer() failure, unable to read from file
O/S-Error: (OS 112) There is not enough space on the disk.


Can its possible to shirnk the objects found in the tablespace but its segment type is different or we need to increase our rollback segment parameter high for your information our rollback segment parameter value is shown below


SQL> show parameter rollback_segment

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_rollback_segments                integer     73
rollback_segments                    string
transactions_per_rollback_segment    integer     5



thanks,
Re: ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1' [message #352084 is a reply to message #352074] Mon, 06 October 2008 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Can its possible to shirnk the objects found in the tablespace

Not in UNDO tablespace

Quote:
we need to increase our rollback segment parameter high for your information our rollback segment parameter value

Irrelevant with undo tablespace.

Regards
Michel
Re: ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1' [message #352111 is a reply to message #352084] Mon, 06 October 2008 03:52 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
Is there is any way to resolve the issue

Thanks,
Re: ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1' [message #352116 is a reply to message #352111] Mon, 06 October 2008 04:03 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
- Find if there is no session that has been left without committing (TOAD for instance)
- Enlarge your undo tabespace
- Decrease your undo_retention parameter

Also some 9i versions have a bug that precludes Oracle from releasing free space. Have a look at Metalink if your are impacted by this.

Regards
Michel
Previous Topic: merging Databases
Next Topic: sga_max_size - how to find the max value for AIX 5L
Goto Forum:
  


Current Time: Sat Dec 07 03:43:27 CST 2024