- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- increase in run time after converting rollback seg...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-20-2008 02:00 AM
тАО02-20-2008 02:00 AM
increase in run time after converting rollback segments to undo
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-20-2008 02:31 AM
тАО02-20-2008 02:31 AM
Re: increase in run time after converting rollback segments to undo
did you place this issue in oracle metalink?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-20-2008 04:04 AM
тАО02-20-2008 04:04 AM
Re: increase in run time after converting rollback segments to undo
not yet placed this issue in metalink
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-20-2008 04:25 AM
тАО02-20-2008 04:25 AM
Re: increase in run time after converting rollback segments to undo
What release of 10g?
PS: re-check your points assignment policy...
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-20-2008 04:25 AM
тАО02-20-2008 04:25 AM
Re: increase in run time after converting rollback segments to undo
What release of 10g?
PS: re-check your assignment policy...
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-20-2008 04:49 AM
тАО02-20-2008 04:49 AM
Re: increase in run time after converting rollback segments to undo
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-20-2008 09:11 AM
тАО02-20-2008 09:11 AM
Re: increase in run time after converting rollback segments to undo
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