RE: ORACLE 8.1.5 on NT run very slow ??

2001-10-25 Thread Boivin, Patrice J
of list ORACLE-L Subject:RE: ORACLE 8.1.5 on NT run very slow ?? Hi, If you open up task Manager on the server, and swap to the performance tab, how much physical memory is shown as available? While you're on that tab, how much total physical memory

Re: ORACLE 8.1.5 on NT run very slow ??

2001-10-24 Thread Jared . Still
aaa aaa, ( if that's your real name :) Considering that your page faults are very high, take a look at the sizes of db_block_buffers, db_block_size, and shared_pool_size for starters. 512 Meg of RAM isn't exactly an overabundance, but will perform especially badly if you've allocated all of it

RE: ORACLE 8.1.5 on NT run very slow ??

2001-10-24 Thread Reardon, Bruce (CALBBAY)
Hi, If you open up task Manager on the server, and swap to the performance tab, how much physical memory is shown as available? While you're on that tab, how much total physical memory does Task Manager report? As per Jared's question, what do the following 2 queries show? select * from v$sga;