Re: Recommendations

No, they don't need any special initialization parameters. But we can't upgrade to 9 or 10 because our primary application (payroll) is not supported beyond 8.1.7 (yet).\

Interesting stuff on RAID 5, which I was not aware of.

I presume we should have at least a distinct table space for each of the major apps?

Also, I am not totally clear on the difference between an "instance" and a "database". It looks to me like they are nearly the same thing. Is it possible we would want a separate database for an application, but not a separate instance?

Volker Hetzer wrote:

>Several instances mean a more or less static distribution of memory.
>Personally I'd try to avoid this and let oracle handle the memory
>allocation.
>Do your apps require different and mutually exclusive initialisation
>parameters that can not be set per session?
>If yes, you're out of luck and have to do several instances.
>
>
>
>>Several of the applications will share some of the same tables.
>>
>>
>Same instance or dblink. I've never done dblink and therefore would
>go with the "same instance" approach.
>
>
>
>>The server is a Pentium IV 2.2 Xeon dual processor with 1 gig of RAM and
>>RAID 5.
>>
>>
>http://www.miracleas.dk/BAARF/BAARF2.html
>
>Also, is there any reason not to upgrade to 9i or 10g?
>
>Lots of Greetings!
>Volker
>
>
Received on Mon Jun 07 2004 - 10:25:14 CDT