Re: Finding which DB is consuming max resources

"Billy Verreynne" <vslabs_at_onwe.co.za> schreef in bericht news:1a75df45.0308110137.71b584e6_at_posting.google.com...
> learning_dba_at_yahoo.com (Mike) wrote
>
> > 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?
>
> Hell Mike, you said 25 in the other post. Now there's 30. Where do
> these new 5 databases come from?
>
> Written slowly using nice and large and friendly letters....
>
> I t i s a V E R Y B A D ID E A ( T M ) t o r u n t h a
> t m a n y p h y s i c a l i n s t a n c e s o n a s i n
> g l e p l a t f o r m.
>
> That is NOT how one designs and desploys physical Oracle databases.
> Period.
>
> --
> Billy

Hi Billy,

I'm a bit surprised about your pertinent statement. As always in DBA-land I would say: it depends. If most of these databases are practically not consuming any resources why wouldn't you? What would you consider a reasonable maximum?

regards,
Peter Received on Tue Aug 12 2003 - 08:32:26 CDT