Re: Urgent!!! Upgrade Oracle and Hardware question ?

"Frank" <mostadam_at_yahoo.com> wrote in message news:8bca69a5.0206191146.7216a00c_at_posting.google.com...
> We have
>
> Oracle 8.0.5 on Win NT 4.0
>
> We move to
>
> Oracle 8.1.6 on Win 2k advance server
>

You know 8.1.6 is desupported, don't you? So you are moving from one desupported version to one slightly less desupported version??

Doesn't seem to make a lot of sense to me.

> Questions for Gurus:
>
> Any danger that performance decrease??? I heared some folks some
> stored procs after these kind of upgrade getting very slow.
>

Great danger. 8i is to 8.0 what chalk is to cheese. It's more resource hungry. The internals got different (otherwise it wouldn't be an upgrade, would it?). There are newer and more efficient ways of doing things. And old ways of doing things might become slightly more expensive.

What I tend to recommend is that you clone your database, upgrade the clone, and test and test and test until you know the pros and cons. Only then consider upgrading the real production database.

>
> What is the Hardware config you best recommended. Mostly about Hard
> Drive, RAID and Tape Backup and Network card
>

My first recommendation is that you don't upgrade to 8.1.6. It's de-supported and has certain , er, gratuitous, extraneous and unexpected, er, "features" shall we call them? (Bugs if you'd prefer). 8..1.7 is a supported version and is much more reliable.

> For CPU we will use Dual Dell PowerEdge and We will have 2 GIG RAM but
> Hard Drive we dont know.

I have shares in Seagate. I recommend (completely unbiasedly, of course) Seagate Hard Drives to all my students. Avoid Quantum hard drives as they give you veneral disease. IBM hard drives give you Alzheimers. Only Seagate hard drives make your teeth pearly white... er, I mean... CUT!... give you peace of mind.

>DB size is aroung 40 GIG but will expand to
> 100 GIG in 3 years.
>

Peanuts. A nice Seagate RAID 0+1 array will do fine. Steer clear of RAID 5 (it makes the elastic in your underpants disintegrate). Just make sure to buy as many hard disks as you can afford (say, 9 minimum, preferably 36).

Regards
HJR
> Thanks for replies in advance.
Received on Wed Jun 19 2002 - 23:02:35 CDT