|
Snapshot Level Table Application Lock |
Logical Data Grouping table appl sqml_appl_lock lock lock_wait |
Monitor Switch Table Lock Lock Lock Lock |
|
Resettable |
No |
|
|
Event Type Table Deadlock |
Logical Data Grouping table_event dlconn_event |
|
|
Element Name Element Type |
table_name information |
Description: The name of the table.
Usage: Along with "Table Schema Name", this element can help you determine the source of contention for resources.
At the application-level, application-lock level, and deadlock-monitoring-level, this is the table that the application is waiting to lock, because it is currently locked by another application. For snapshot monitoring, this item is only valid when the "lock" monitor group information is turned on, and when "Lock Object Type Waited On" indicates that the application is waiting to obtain a table lock.
For snapshot monitoring at the object-lock level, this item is returned for table-level and row-level locks. The table reported at this level is the table against which this application holds these locks.
For snapshot and event monitoring at the table level, this is the table for which information has been collected. This element is blank for temporary tables, reorganization tables, and tables that were dropped. Table names are only provided for catalog and user tables. For snapshot monitoring, this element is only valid when the "table" monitor group information is turned on.