Re: To dual processor or not?

Well, it is not ideal but sometime we have to live with limited budget. Anyway from what I understand, the database won't be too busy. Just for data entry and running daily, weekly and monthly query. PS. Only about 10 clients will use the database at a time. The rest of the client will be used for doing office works.

I think my frinds just want to know whether it will increase database performance to add a second processor since the system is capable to do it.

BTW, do we have to do anything to enable multiprocessor at database installation or it will be enabled automatically depending on the OS/System?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:uhj2aj3u138la1_at_corp.supernews.com...
> Running the other stuff on a box with Oracle is also a safe recipe for
> disaster.
> A similar system wouldn't qualify for remote maintenance in my firm.
>
> Regards
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
> "David Lord" <davelord_at_hotmail.com> wrote in message
> news:afc0hk$j31$1_at_nntp-m01.news.aol.com...
> > Is that 512Mb for the whole Server or just for Oracle? That's not much
> for
> > the OS, Oracle and the other things you mention for a user group of 25
> > people, especially if the OS is W2K or XP.
> >
> > In any case you should get the extra processor if this team is anywhere
> near
> > busy all the time, but another 512Mb would be helpful as well. It's not
> > clear what Oracle is going to be doing so it's impossible to give a more
> > solid answer.
> >
> >
> > "Hartono Nugroho" <hanugro_at_hotmail.com> wrote in message
> > news:3d191f84$1_4_at_news5.nntpserver.com...
> > > It is the only server in the department so it may run DHCP, DNS, file
> > > server, print server for only about 25 clients.
> > >
> > > Regards,
> > > Hartono
> > >
> > > "Priyesh Patel" <priyesh_at_mercurie.co.uk> wrote in message
> > > news:afa9l3$su6$1_at_shale.ftech.net...
> > > > If you have other applications running on the server then a second
> > > > processor would help as it would reduce the contention between
Oracle
> > and
> > > > other processes. Otherwise, more memory or disks would be a better
> > > > investment.
> > > >
> > > > Also if you don't have named user licenses, there are additional
> license
> > > and
> > > > support costs you need to worry about.
> > > >
> > > > Regards
> > > > Priyesh
> > > > www.mercurie.co.uk
> > > >
> > > > "Hartono Nugroho" <hanugro_at_hotmail.com> wrote in message
> > > > news:3d17c621$1_6_at_news5.nntpserver.com...
> > > > > Hi all,
> > > > >
> > > > > My friends site want to setup small (departmental) Oracle database
> > with
> > > > only
> > > > > 512MB of memory. They are wondering whether they should add
another
> > > > > processor (P3 Tualatin based) on the server (dual proc capable).
> > > > > Any idea whether adding another processor with such a limited
memory
> > > will
> > > > > benefit Oracle?
> > > > > Thanks in advance for any tip.
> > > > >
> > > > > Regards,
> > > > > Hartono
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Fri Jun 28 2002 - 05:21:06 CDT