Re: Slow Database on Sun E450?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 3 Apr 2001 10:34:08 +0100
Message-ID: <986290465.4486.0.nnrp-07.c30bdde2@news.demon.co.uk>

Did you even read my post? The reasons for your slowdown are quite clear...

You have 1gb of RAM, and 1.63gb buffer cache (209026 x 8192). Even 50,000 db_block_buffers would probably be way too much. Are you familiar with paging and swapfiles at all?

And that's before we add your 285mb shared pool, 20mb java pool, oracle process overhead and operating system.

This is the *first* place any admin/dba would look... which is a bit worrying really...

"Tiger Woods" <clintonn_at_meb.co.za> wrote in message news:3ac8aba1$0$223_at_hades.is.co.za...
> You guys aren't going to believe this, but I kept all the parameters that
I
> was using previously, and switched to dedicated mode, and this has sorted
> the database out.
> There are no more hanging scripts etc.
>
> Thanks for the help.
Received on Tue Apr 03 2001 - 04:34:08 CDT