Database - RAC/Scalability (MOSC)

MOSC Banner

one Table generating gc traffic upon single active instance cluster

edited Mar 21, 2013 4:31AM in Database - RAC/Scalability (MOSC) 1 commentAnswered
Hello,

We are running an Oracle RAC database across two nodes with only one active instance i.e. second node is in secondary mode. We are using RAC for availability and resilience only and not scalability and every two weeks the primary role is passed from one node to the other. This has been running without any issues for the last 4 years. However over the last few days there have been some recorded instances of selects upon one table 'replication_queue_mes_b' giving poor response times. So far these incidents of poor response time have occurred when the primary instance was running upon

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center