|
Snapshot Level Table Application Lock |
Logical Data Grouping table appl 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_schema information |
Description: The schema of the table.
Usage: 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 Waited On" 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 turned 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.
For snapshot and event monitoring at the table level, this element identifies the schema of the table for which information has been collected. This element is blank for temporary tables, reorganization tables, and tables that were dropped. Schema names are provided only for catalog and user tables. For snapshot monitoring, this element is valid only when the "table" monitor group information is turned on.