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.
cesar_echeverriAsked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.