Re: Slow Database on Sun E450?

100%.

The part where I said "I have 2gb, not 1gb of ram, mistaken there)." actually meant that I was mistaken.

Bit of a weird problem though, and Oracle suport are still scratching their head to figure this one out.
The server itself is fine and was idling when the scripts were hanging.

Thanks for the help again.

Clint

"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message news:986381167.16100.0.nnrp-12.c30bdde2_at_news.demon.co.uk...
> 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 Thu Apr 05 2001 - 05:38:58 CDT