Re: how much memeory is needed by 8.0.5 on Sun ES10k system on average

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 3 Dec 2000 16:28:34 +0100
Message-ID: <90dp78$pb4m$6@ID-62141.news.dfncis.de>

The only way to know that is to determine the buffer cache hit ratio, the library cache hit ratio, and the dictionary cache hit ratio, in short run utlbstat and utlestat.
Everything else is just guess work.

Regards,

Sybrand Bakker, Oracle DBA

"Harold Pearson" <haroldPer_at_hotmail.com> wrote in message news:3a2a47cf$0$14421$45beb828_at_newscene.com...
> we have sun ES10K with around 200 million rows in tables in ~ 30 schemas
with
> around 100 users. Mostly small amounts of selects, but sometimes massive
> loads of 30-40 million rows or scans of tables with 20-40 million rows
>
> we have 1165M ram allocated, is that enough?
Received on Sun Dec 03 2000 - 09:28:34 CST