[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 553
  • Last Modified:

SLOW RAC

We have problems  running  a RAC database when we are initiating it the first time, aparently there are a pz99 process that consumes all resources and the database slowdown.
0
cesar_echeverri
Asked:
cesar_echeverri
1 Solution
 
gvsbnarayanaCommented:
Hi,
   How was your application runnin on non-RAC machine? Was it running fine or are there any problems? If you have problems on a single instance, then there will be lot more problems on RAC database.
What's the biggest wait event on the RAC database? is it "gc cr block 2-way"?
What's the parallelism of the indexes that are highly used? If the parallelism is set to a high value, then there will be processes started on all the nodes for each query and there will be lots of inter-node traffic which will effect your performance on RAC database.
Can you please send the AWR report of the instances? It would be easier to monitor the RAC database on Oracle Enterprise Manager.
HTH
Regards,
Badri.
0
 
cesar_echeverriAuthor Commented:
The problem have to do with the "REMOTE LISTENER" parameters

Thanks,

César E.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now