Re: Automatic Shared Memory Management Advice

Sybrand Bakker wrote:
>
> On Mon, 05 Dec 2005 19:24:00 -0500, ohaya <ohaya_at_cox.net> wrote:
>
> >Obviously, I've never done anything like this before :(, and I'm
> >wondering what the possible downsides might be?
>
> The current values seem to be quite adequate. The only problem is your
> server has insufficient memory, especially if you are running the
> whole Oracle iAS product from one single box.
> Evidently the downside is, that your database is going to experience
> performance problems.
> I would take my creditcard and buy more memory.

Sybrand,

Thanks for replying. I know that I should get more memory, but given that this is an old, used machine, and because this is probably a one-shot deal, I'm having a hard time justifying putting more money into it (the machine). I was just hoping that if I could maybe reduce the SGA memory requirements, I could "stretch" things a bit, since Oracle performance isn't an issue for my installation testing purposes. The main thing I'm concerned about if I try this is causing problems (e.g., ORA-... errors).

I've already killed off all of the Solaris processes that appear to be unnecessary.

Jim Received on Tue Dec 06 2005 - 05:11:53 CST