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.
Dig deeper on Oracle and SQL
Related Q&A from Mike Ault, Senior Oracle Consultant, Burleson Consulting
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...continue reading
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.continue reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.