increase in run time after converting rollback segments to undo

[Nirmalkumar]

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

[Jeeshan]

what is the retension period in undo tablespace?

did you place this issue in oracle metalink?

[Nirmalkumar]

retention period of undo tablespace is 1.5hrs

not yet placed this issue in metalink

[Eric Antunes]

Hi Nirmal,

What release of 10g?

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

Eric

[Eric Antunes]

Hi Nirmal,

What release of 10g?

PS: re-check your assignment policy...

Eric

[Nirmalkumar]

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]

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