Exadata General (MOSC)

MOSC Banner

GPnP Initialization, GPnP Get Item and GPnP Termination waits in session trace

edited Nov 7, 2016 8:24AM in Exadata General (MOSC) 1 comment

Systems are 12c Exadata.

I have a single session repeatedly executing a query.  The plan for the query includes "cell smart scan".  The session spends a lot of time waiting on GPnP waits, and its trace file includes repeatedly (about every second) accessing the gpnp daemon to get the ASM-Profile.DiscoveryString.

I've seen this on another 12c Exadata system once before with an update statement, that was repeatedly executed by sessions which disconnected and reconnected between each execution.  Always connecting to the same node.  A restart of the node cleared up the GPnP waits, and they have not come back for two weeks.

Tagged:

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