Re: undo header congestion? (8.0.5)

Howard J. Rogers wrote:

> No, because whoever told you the rule was 'per 4 users 1 rollback segment'
> has got it slightly, but horribly, wrong. The number of users is completely
> irrelevant. It's the number of concurrent transactions that is important. So
> instead of doing a select count(*) from v$session, you would be better off
> doing a select count(*) from v$transaction.

> Regards
> HJR
The reason for the misunderstanding, I presume, is the init parameter.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)