Re: Slow Database on Sun E450?

Easy.

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:3ac85362$0$225_at_hades.is.co.za...
> Hi.
>
> We are actually at a loss, the 450 is a dual processor server with 1gb
 ram,
> 100gb hard drive space.
> While the Ultra 10, is basically a developers desktop, and the Ultra 10
> flies.
> The database is not doing anything when we do inserts, but the insert
 hangs
> for up to 2 minutes at a time.
> Here are the ini files for the 2 databases. Devdb is on the Sparc 10,
 while
> Trinity is on the E450
>
> Let me know what you think?
>
> Thanks
> Clint
>
> .
>
>
> "Andrew Mobbs" <andrewm_at_chiark.greenend.org.uk> wrote in message
> news:b+f*-pHSo_at_news.chiark.greenend.org.uk...
> > Tiger Woods <clintonn_at_meb.co.za> wrote:
> > >Hi.
> > >
> > >Just curious to know if anyone out there has had any performance
 problems
> > >
> > >with Oracle on a Sun E450 server before?
> > >
> > >Our database is a dog at the moment compared to the same spec database
> > >
> > >running on a Sun Ultra 10.
> > >
> > >I am running an Oracle 8.1.7 database (Enterprise Edition) without any
> > >installed patches.
> > >
> > >Any info would be appreciated.
> >
> > Our E450s run fine.
> >
> > You've got 10 times as much RAM in the Ultra 10?
> >
> > You've put a single 250MHz USII in the E450 and a 440MHz USII in the
> > Ultra 10?
> >
> > You've got a single 5400 rpm disk on the E450 and a multi-hundred
> > spindle caching RAID on the Ultra 10?
> >
> > Or possibly the databases are configured differently?
> >
> > Any info would make it easier to help you.
> >
> > --
> > Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
>
>
>
Received on Mon Apr 02 2001 - 06:01:50 CDT