29
Sep
11

Wait Events – cursor: pin S wait on X cursor:

pin S wait on X A session waits for this event when it is requesting a shared mutex pin and another session is holding an exclusive mutex pin on the same cursor object.

Wait Time:

Microseconds

Parameter Description:

P1 Hash value of cursor

P2 Mutex value (top 2 bytes contains SID holding mutex in exclusive mode, and bottom two bytes usually hold the value 0)

P3 Mutex where (an internal code locator) OR’d with Mutex Sleeps


0 Responses to “Wait Events – cursor: pin S wait on X cursor:”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Its Mee :)


Welcome to My Blog:
In this Blog you will find the Oracle stuff which i came across and experienced as DBA. So would like to share with you all so that everyone gets benefited.

September 2011
M T W T F S S
« Aug   Nov »
 1234
567891011
12131415161718
19202122232425
2627282930  

Blog Stats

  • 42,400 hits

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: