Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8 on NT......Slow
"Stallan, Tony (EXCHANGE:BRW2:S901)" wrote:
> Hi folks,
> After increasing/decreasing buffer/pool sizes I've come to the conclusion
> that I don't have enough Ram to meet my needs. There is just too much
> swapping going on.
> I've installed Personal Oracle 8 which has a much smaller footprint and that
> is working okay although the logon times are appalling (See my latest
> posting).
> Thanks to everyone for their advice, I've learnt a lot in the past few days.
> Tony Stallan
A very common problem in moving from Oracle7 to Oracle8 is forgetting or failing to analyze tables, leaving the cost based optimizer starved for information. Make sure you analyze your tables after you migrate.
Best of luck.
-Tom
Received on Mon Apr 05 1999 - 16:27:06 CDT