Re: Largest Oracle8 on NT box?

I have worked with an Oracle 7.x database of about 140-145 GB on NT. The server was a Dell 4 300 Mhz pros with 1 GB memory. Most of the applications did nothing more than reference packages and these did most of the work. We pinned the largest and most used packages in memory and any triggers of any substance did nothing but reference procedures to reduce the workload caused by the triggers being recompiled on each firing. By allowing the packages to do most of the work, we also made our applications far less platform dependant.

We had significant problems with the applications prior to implementing the packages and new triggers. Also, the vast majority of our objects were read-only.

DB

Mark Gornicki <mark_at_gornicki.freeserve.co.uk> wrote in message news:7hnfse$99m$1_at_news4.svr.pol.co.uk...
> Hi,
>
> does anyone know what is largest operational Oracle8 DB on NT4.0?
>
> i know it depends on machine setup etc, i would just like to know what is
> the largest that someone has implemented. I am looking at a 60 gig - 80
gig
> database and would like to know if it is feasible and responsive.
>
> TIA
> Mark Gornicki
>
>
Received on Mon May 17 1999 - 00:04:28 CDT