- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: reducing the rollback segment from oracle
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
тАО11-12-2002 01:41 AM
тАО11-12-2002 01:41 AM
does the rollback segment in oracle clears itself after commiting a transaction?
because i have seen from one of our boxes that the tablespace allocated to RBS is quite big and i want to deallocate some of this to other tablespace. is it safe to remove reduce rbs?
(hp-ux version is 10.20 oracle 8.0.4)
thanks,
danny
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 02:03 AM
тАО11-12-2002 02:03 AM
Re: reducing the rollback segment from oracle
You can manually shrink a rollback segment by issuing a command like -
ALTER ROLLBACK SEGMENT rbs1 SHRINK TO 100K;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 02:38 AM
тАО11-12-2002 02:38 AM
Re: reducing the rollback segment from oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 03:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 03:53 AM
тАО11-12-2002 03:53 AM
Re: reducing the rollback segment from oracle
svrmgrl> alter rollback segment
K -- size in KB
M -- size in MB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 04:49 AM
тАО11-12-2002 04:49 AM
Re: reducing the rollback segment from oracle
I assume you're an Oracle customer and therefore have access (once registered) to this web site.
You may find other information regarding your question
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 04:51 AM
тАО11-12-2002 04:51 AM
Re: reducing the rollback segment from oracle
Be careful not to reduce the RBS tablespace too much after reducing the rollback segments as this might result in errors when the rollback segment expands due to large transactions.
also you should not set the OPTIMAL size too low as Oracle then will spend more time allocation and deallocationg space for the rollback segments.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-12-2002 05:52 AM
тАО11-12-2002 05:52 AM
Re: reducing the rollback segment from oracle
Set the OPTIMAL parameter for the rollback segements. That will help, but it might take a while. You can also use the Oracle Enterprise Manager to shrink the rollback segments
( Tools -> Database applications -> Storage Manager -> ORACLE_SID -> rollback segments ).
Reducing the RBS tablespace might be the reason for future problems.
If you run large amounts of data manipulating
Oracle statements, you will need the actual space. We have this problems, because we do a database refresh from an external database every day. Our database is not too big, but the amount of data coming over requires some big RBS tablespace. If you go for automatic committing, do not forget, that you might have trouble, if your job breaks off half way through.
Just my 2 ct.
Rgds
Alexander M. Ermes