Database - RAC/Scalability (MOSC)

MOSC Banner

disabling DRM after looking at the stats

edited Aug 29, 2014 5:01AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

Hello,

Is this recommended to disable DRM from below stats in a 2 node RAC. This is report within 7 hrs.

Counts per OpsTime per Ops (seconds)Affinity Objects
I#Remaster OpsRemastered ObjectsReplay Locks ReceivedReplay Locks SentResources CleanedRemasterQuiesceFreezeCleanupReplayFixwriteSyncBeginEnd
1151.931,877.33647.870.000.340.070.010.020.050.020.142522
2151.93671.801,860.000.000.340.080.010.020.060.020.132730
Avg151.931,274.571,253.930.000.340.070.010.020.050.020.142626
Max 1,877.331,860.000.000.340.080.010.020.060.020.142730

Secondly,why does this freeze GRD while doing remastering- I understand that no action can be done on GRD while remastering of block.

Can we see this(locking of GRD)  in v$ges_enqueue?

Best regards,

Vishal

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