From: "andrew_webby at hotmail" Newsgroups: comp.databases.oracle.server Subject: Re: Slow Database on Sun E450? Date: Wed, 4 Apr 2001 11:45:45 +0100 Message-ID: <986381167.16100.0.nnrp-12.c30bdde2@news.demon.co.uk> References: <3ac840e4$0$231@hades.is.co.za> <3AC89D86.CC562BF@uk.sun.com> <3ac8aba1$0$223@hades.is.co.za> <986290465.4486.0.nnrp-07.c30bdde2@news.demon.co.uk> <3acaa75d$0$228@hades.is.co.za> NNTP-Posting-Host: mailgate.highland.gov.uk X-NNTP-Posting-Host: mailgate.highland.gov.uk:195.11.221.226 X-Trace: news.demon.co.uk 986381167 nnrp-12:16100 NO-IDENT mailgate.highland.gov.uk:195.11.221.226 X-Complaints-To: abuse@demon.net X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Lines: 56 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" wrote in message news:3acaa75d$0$228@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" wrote in message > news: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" wrote in message > > news:3ac8aba1$0$223@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. > > > > > > > >