Re: Finding which DB is consuming max resources

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...

HTH,
Brian

Mike wrote:
>
> Hi All,
>
> I have about 30 databases running on Oracle 8.05 on my server.The OS
> is HP-Unix 10.2.
> Can I find out which database is consuimg the maximum memory?
>
> TIA
>
> Mike

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"