| rollback segments [message #169107] |
Tue, 25 April 2006 02:14  |
nani_ar
Messages: 58
Registered: March 2006
|
Member |
|
|
Hi,
I have heard, that the no of shrink or wraps should be minimum for good performance.
What should be the value of shrinks or wraps and how to minimise them. I m using 8i and LMT for RBS
All replies r welcome
regards
nani
|
|
|
|
| Re: rollback segments [message #169129 is a reply to message #169107] |
Tue, 25 April 2006 04:14  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Why don't you just upgrade to 9i or 10g and start using automated undo (UNDO_MANAGEMENT=TRUE)?
If you can, you don't have to worry that much about tuning your rollback segments to perfection as Oracle will do it for you!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
