Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

increase in run time after converting rollback segments to undo

Nirmalkumar
Frequent Advisor

increase in run time after converting rollback segments to undo

Hi all,

i have changed rollback segments to undo segments last week in one database.after changes,application ppls are saying that the one process is taking much time(14 mins in undo) compared to older ( less than 2 mins in rollback segments).
please help me how to proceed to solve the issue.
version of oracle is 10g.
Note: the undo tablespace is autoextend.

Thanks,
Nirmal
6 REPLIES
Jeeshan
Honored Contributor

Re: increase in run time after converting rollback segments to undo

what is the retension period in undo tablespace?

did you place this issue in oracle metalink?
a warrior never quits
Nirmalkumar
Frequent Advisor

Re: increase in run time after converting rollback segments to undo

retention period of undo tablespace is 1.5hrs

not yet placed this issue in metalink

Eric Antunes
Honored Contributor

Re: increase in run time after converting rollback segments to undo

Hi Nirmal,

What release of 10g?

PS: re-check your points assignment policy...

Eric
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: increase in run time after converting rollback segments to undo

Hi Nirmal,

What release of 10g?

PS: re-check your assignment policy...

Eric
Each and every day is a good day to learn.
Nirmalkumar
Frequent Advisor

Re: increase in run time after converting rollback segments to undo

Hi Eric,

Thanks for the response.

My oracle version:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit.

i could not understand what is meant by assignment policy.

Thanks
Nirmal.



Eric Antunes
Honored Contributor

Re: increase in run time after converting rollback segments to undo

Hi,

About the Undo tablespace, please post the following result:

select name, value
from v$parameter where name like '%undo%'

About point assignment, read this:

http://forums11.itrc.hp.com/service/forums/helptips.do?#22


Eric
Each and every day is a good day to learn.