Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8 on NT......Slow

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

From: Thomas Cox <thomasbcox_at_home.com>
Date: Mon, 05 Apr 1999 21:27:06 GMT
Message-ID: <37092A69.1E38EA57@home.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US