Just want to know Guru's opinion,
What is the problem if I will keep more or extra no. of RBS online.
Hard Disk space is not a issue for me et all. What other impacts I may see because of it. Any negative impacts.
AFAIK, No -ve impact at all on the database.
But make sure you limit the number of extents on the RBS. If you have too many RBS with too many extents it might more resources to extend and shrink....
[Edited by sreddy on 06-11-2002 at 04:07 PM]
It depends on what kind of transactios you have on the database, let say you have very big transaction(s) , which can cause huge undo and you also have a many small rollback segments , Oracle will still bless you with ORA-1555.
Size does Matter, may not be number always
no negative impact , in fact in 9i if you want to keep an old enough undo in order to use flahsback query you might as well have a huge undo tablespace
Click Here to Expand Forum to Full Width