Re: Slow Database on Sun E450?

You were wrong - not me. You clearly stated you had 1gb of RAM. Mine was the right answer - though you did appear to have additional problems with this shared/dedicated deal.

If you did have 1gb - as you posted - then that would have *most likely* been why you were running slow...

"Tiger Woods" <clintonn_at_meb.co.za> wrote in message news:3acaa75d$0$228_at_hades.is.co.za...
> Sorry Andrew, but you are wrong here.
> All the parameters are the same as before (I have 2gb, not 1gb of ram,
> mistaken there).
> The changing from shared to dedicated seemed to have done the trick,
> although Oracle suport themselves cannot explain why this would happen.
>
> Thanks anyhow.
>
> Clint
>
>
> "andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message
> news:986290465.4486.0.nnrp-07.c30bdde2_at_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 Wed Apr 04 2001 - 05:45:45 CDT