Re: Oracle8 on NT......Slow

One thing you can try (without adding more memory) is to increase Virtual Memory of NT. You can click System icon in Control Panel. Under Performance, in Virtual Memory section, click Change. Increase the virtual memory and check the performance.

Tony

Stallan, Tony (EXCHANGE:BRW2:S901) <stallan_at_americasm01.nt.com> wrote in article <370387D7.487C5940_at_americasm01.nt.com>...
> Hi folks,
>
> I have installed Oracle8 onto my NT box (350Mhz, 68Mb Ram) and am
> encountering poor performance when compared to my original setup of
> Personal Oracle 7 on Win 95 (same box).
>
> As this is a development environment I am the only user of this system
> and the NT box is not connected to a network.
>
> A Select statement made on the PO7/W95 system takes less than 1 sec
> where the same statement on O8/NT takes ~ 8 secs. I also posted a
> message yesterday about the lack of speed when Inserting records and I
> made the recommended changes (thanks) to Init.ora but to no avail. In
> fact I have tried many different combinations of changes to Init.ora all
> of which made no difference.
>
> My current feeling is that I may not have enough memory to handle both
> NT/Oracle8 effectivly. So is 68Mb Ram and a 64Mb paging file enough.
> Remember that I am the only person using this system and I have not got
> a multitude of applications open.
>
> I wanted to go to Oracle 8/NT to get a better performing system but at
> the moment I feel like going back to PO7/W95.
>
> Many thanks in advance for any advice given
>
> Tony Stallan
>
>
Received on Thu Apr 01 1999 - 17:07:13 CST