disabling DRM after looking at the stats
Hello,
Is this recommended to disable DRM from below stats in a 2 node RAC. This is report within 7 hrs.
Counts per Ops | Time per Ops (seconds) | Affinity Objects | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
I# | Remaster Ops | Remastered Objects | Replay Locks Received | Replay Locks Sent | Resources Cleaned | Remaster | Quiesce | Freeze | Cleanup | Replay | Fixwrite | Sync | Begin | End |
1 | 15 | 1.93 | 1,877.33 | 647.87 | 0.00 | 0.34 | 0.07 | 0.01 | 0.02 | 0.05 | 0.02 | 0.14 | 25 | 22 |
2 | 15 | 1.93 | 671.80 | 1,860.00 | 0.00 | 0.34 | 0.08 | 0.01 | 0.02 | 0.06 | 0.02 | 0.13 | 27 | 30 |
Avg | 15 | 1.93 | 1,274.57 | 1,253.93 | 0.00 | 0.34 | 0.07 | 0.01 | 0.02 | 0.05 | 0.02 | 0.14 | 26 | 26 |
Max | 1,877.33 | 1,860.00 | 0.00 | 0.34 | 0.08 | 0.01 | 0.02 | 0.06 | 0.02 | 0.14 | 27 | 30 |
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