| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Caching Problem in OPS
I'm confused by what you ar trying to achieve with the Parallel Server part.
If you've installed it on one machine but not the other, you can't use OPS.
Are the two machines clustered? Parallel Server is only used in a clustered
configuration to access a single database on shared disk from two or more nodes
of the cluster. If that's not what you're trying to do, I'd remove OPS from
the equation first. You will be taking up unnecessary resources with the DLM
if nothing else.
The problem, however, is probably not related to that. We need more information. Is anything else happening on Machine A that would flush the data buffer cache? Are there other users doing things? Are the two machines using different values for things like db_buffer_cache? How are the disks laid out? etc. etc.
Dicky wrote:
> 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!
--
Regards
Pete
Peter Sharman Email: psharman_at_us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local)San Francisco
SQL> select standard_disclaimer, witty_remark 2 from company_requirements;
Opinions are mine and do not necessarily reflect those of Oracle Corporation
"Controlling application developers is like herding cats."
Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!"
Bruce Pihlamae, long term ORACLE DBA
Received on Tue Mar 09 1999 - 11:58:51 CST
 |
 |