Re: Finding which DB is consuming max resources

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 12 Aug 2003 18:06:35 +1000
Message-ID: <3f38a674$0$10355$afc38c87@news.optusnet.com.au>

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F37C0D4.31D5FDBF_at_remove_spam.peasland.com...

> Sign on to each of your 30 instances (or is it 25? Your posts conflict
> with each other) with SQL*Plus and issue SHOW SGA. This will give you
> the memory for the *shared* portion of the instance. That's a start...
>

don't worry. there was one the other day somewhere else asking for how to run 100 instances in the same box. and he got meaningful replies...

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue Aug 12 2003 - 03:06:35 CDT