DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - gcs remastering wait for drop pkey

gcs remastering wait for drop pkey

In Real Application Clusters, the Global Cache Service and Global Enqueue Service has the feature called resource affinity. Resource Affinity is the use of dynamic resource remastering to move the location of the resource masters for a database file to the instance where resource operations are most frequently occuring. This optimizes the system in situations where update transactions are being executed on one instance. When activity shifts to another instance the resource affinity will correspondingly move to the new instance.

Dynamic resource remastering is the ability to move the ownership of a resource between instances of real Aapplication Clusters during runtime and without affecting availability. A session dropping an object waits on the lock manager daemon (LMD) to remove the object's affinity to an instance. Wait Time:

20 centi-seconds

Parameter

Description

pkey

The object id of the database object being dropped