Archives of the TeradataForum
Message Posted: Thu, 10 Mar 2005 @ 14:59:03 GMT
Teradata RDBMS SQL Reference - Statement and Transaction Processing 7 ? 7
It is possible to exhaust Lock Manager resources. Any transaction that requests a lock when Lock Manager resources are exhausted aborts. In such cases, row hash locking for DDL statements can be disabled.
You can review all the active locks and determine which other user locks are blocking your transactions if you have the performance monitor MONITOR SESSION privilege and an application that uses the Performance Monitor/Application Programming Interface.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|