Re: GB Datafiles on W2K3 server

realbeaux_at_yahoo.com wrote:
> I am just a lowly database consultant brought into look at things. And
> since my previous background isn't with working with medium size or
> large database, I thought I would get some help from the Oracle
> community.
>
> Why Windows? I didn't make this decision. Sorry, I can give you more.

I don't think the number of datafiles will make any performance difference for your needs, unless you have a request rate so high that you should consider switching OS and hardware anyways. The actual app code will likely be the determining factor, at least until you get it right. Assuming you don't run into silly issues like setting pga-aggregate or the SGA too large and start swapping. You can't really tune that stuff until you get it working.

jg

--
@home.com is bogus.  "HP-UX - Works well, but it's a dead platform. Ask
anyone within HP and you will know that Tru64 and HP-UX are not long
for this world. HP-UX on x86? Yeah, right!" - Tim Hall.