Thanks - that makes sense. A little tougher question is, does anyone
know what amount of overhead the Resource Manager adds to Oracle? I'm
assuming some overhead is involved since now Oracle is trying to
manager CPU resources. Anyone have a clue on this?
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<ada3nm$nmk$1_at_lust.ihug.co.nz>...
> I think you'll find that 'OTHERS' is the back-stop group: when you haven't
> explicitly assigned someone to a group, they go there as a last resort.
>
> HJR
>
>
> "Dave" <dherri_at_acxiom.com> wrote in message
> news:d31a72dc.0205310802.5944eccd_at_posting.google.com...
> > The Resource Manager is not active on my database, but I'd like to set
> > it up to add a group for a user, MONITOR, that will monitor various
> > aspects of the database but impact the existing, production users as
> > little as possible. I created a group called MONITOR_GROUP and gave it
> > 20% on cpu1 and 80% on cpu2. DEFAULT_CONSUMER_GROUP gets 80% on cpu1
> > and 20% on cpu2. OTHERS_GROUP gets 100% on cpu3.
> >
> > My questions are, who gets assigned to OTHERS_GROUP? Where do SYS and
> > SYSTEM go, since they're in SYS_GROUP? Do they bounce down to
> > OTHERS_GROUP?
Received on Mon Jun 03 2002 - 07:30:16 CDT
