OraFAQ Forum: Server Administration » ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1'

Home » RDBMS Server » Server Administration » ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1' (Oracle 9i)

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

ORA-30036: unable to extend segment by 1024 in undo tablespace 'UNDOTBS1' [message #352074]

Mon, 06 October 2008 00:07

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,

Report message to a moderator

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

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
Is there is any way to resolve the issue

Thanks,

Report message to a moderator

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

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 00:24:38 CDT 2024