Re: _rollback_segment_count side effects

That's not a good question.

It doesn't matter what side effects anyone has seen unless you also know what sort of activity their database goes through - so you're asking other people to tell you things about their databases that you should be telling them about your database before you ask the question.

I can think of a couple of *possible *side effects - but they may be completely irrelevant to you, and if I don't give you a context your next question will probably be to ask for an explanation of how or why the side effects night appear.

1. You waste buffer cache unnecessarily
2. you increase the risk of ORA-01628 max # extents (32765) reached for rollback segment

> Hello,
>
> DB Version: 12.1
>
> Is someone played around with parameter _rollback_segment_count ? I`m most
> interested in what are the side effects of increasing this parameter.
>
> Thank you.
>

--
http://www.freelists.org/webpage/oracle-l