Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Contention in RBS Header?
Has anyone reported an ORA-##### error? If so what is it and the text
message.
Has anyone seen anything in one or more of the v$ views that would
indicate that this is a problem?
I can't say whether it exists ... but I can say I've never seen it and that before I went racing after it I'd want to see some evidence pointing to the fact that (A) there is a problem, (B) it relates to rollback segments, and (C) it is not something that could be easily rectified by just adding a few more segments or reducing the number of transactions per segment.
Daniel Morgan
Russell Fray wrote:
> Hi All,
>
> Firstly, apologies if I'm posting to the wrong group - if you could
> point me to a more appropriate group I'd be extremely grateful (I've
> purposely avoided cross posting!)
>
> I've been asked to investigate whether there is contention in the
> Rollback Segment Headers but I'm not sure of the best views to look in
> to get this info.
>
> Could somebody give me a few pointers regarding which views & columns
> I should be looking at and what I should look for? Alternatively if
> there are any scripts?
>
> Any (useful!) replies will be gratefully received.
>
> Thanks,
> Russ.
Received on Mon Apr 15 2002 - 10:40:17 CDT