The schema of the table.
Table Function | Monitor Element Collection Level |
---|---|
MON_GET_TABLE table function - Get table metrics | Always collected |
MON_GET_INDEX table function - Get index metrics | Always collected |
Snapshot Level | Logical Data Grouping | Monitor Switch |
---|---|---|
Table | table | Basic |
Application | appl | Lock |
Lock | appl_lock_list | Lock |
Lock | lock | Lock |
Lock | lock_wait | Lock |
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Locking | - | - |
Tables | event_table | - |
Deadlocks1 | lock | - |
Deadlocks1 | event_dlconn | - |
Deadlocks with Details1 | event_detailed_dlconn | - |
Along with table_name, this element can help you determine the source of contention for resources.
For application-level, application-lock-level, deadlock-monitoring-level, this is the schema of the table that the application is waiting to lock, because it is currently locked by another application. This element is only set if lock_object_type indicates that the application is waiting to obtain a table lock. For snapshot monitoring at the application-level and application-lock levels, this item is only valid when the "lock" monitor group information is set to ON.
For snapshot monitoring at the object-lock level, this item is returned for table and row level locks. The table reported at this level is the table against which this application holds these locks.