Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how much memeory is needed by 8.0.5 on Sun ES10k system on average
well for ora_ckpt we have 1 gig
for ora_lgwr 1 gig
ora_p004 1 gig
ora_dbw0 1 gig
oracle 1 gig
In article <90dp78$pb4m$6_at_ID-62141.news.dfncis.de>, "Sybrand Bakker"
<postbus_at_sybrandb.demon.nl> wrote:
>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 - 10:30:30 CST