Caching Problem in OPS

From: Dicky <ccdicky_at_hotmail.com>
Date: 9 Mar 1999 16:09:26 GMT
Message-ID: <01bdc3af$d64b63c0$01011fb4@steve>

Hi everybody,

I have two RS6000 machines.

			Machine A 	Machine B
			---------	---------
OS			AIX 4.1.5	AIX 4.1.5
Phyical memory		1G		256M
Paging file		640M		256M
7.3.4.3 Oracle server	Yes		Yes
OPS option		Yes		No
SGA size		300M		27M

After restarting the Oracle server on both machines to clear all cache, I run an UNION SQL statment by SQLPLUS program. Due to advanced hardware on Machine A, it runs faster than Machine B (3mins vs. 9mins) in the first run. However, the result seems to be abnormal when I re-run the same statment in the same SQLPLUS session. Machine B only takes 1mins to finish in second run, but run time for Machine A remains as it is. Same outcome as re-running more.

It seems that Machine A cannot take the caching advantage during re-run. I've tried to "startup parallel", "startup exclusive", "startup" Oracle server with OPS option on Machine A, but still produces same result. No help!

I would like to know why Oracle server with OPS option is so slow in re-run. Is it MUST for OPS??

Thanks in advance! Received on Tue Mar 09 1999 - 10:09:26 CST