Ask the Expert

Which sessions are waiting for PCM lock conversion to complete?

Can you provide a SQL statement to determine which of my sessions are waiting and which have already waited for a PCM lock conversion to complete?

    Requires Free Membership to View

GV$DLM_CONVERT_LOCAL/REMOTE displays the elapsed time for the local lock conversion operation and has finer grain details on lock activity. In order to use these views, you need to turn on the event 29700 to gather these statistics. Metalink note: 72316.1 will help you with this.

This was first published in June 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: