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

Obviously you don't understand what I am trying to say, as this list below doesn't have any relation to the performance statistics I was referring to. Try running utlbstat and utlestat. If you don't know what they are, refer to the performance tuning manual.

Regards,

Sybrand Bakker, Oracle DBA

"Harold Pearson" <haroldPer_at_hotmail.com> wrote in message news:3a2a7433$0$3596$45beb828_at_newscene.com...
>
> 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 - 16:53:57 CST