首页 » ORACLE 9i-23c » Wait Event: Wait for Table Lock

Wait Event: Wait for Table Lock

  • 2020/05/23
  • ORACLE 9i-23c
  • 672 views
  • Wait Event: Wait for Table Lock已关闭评论

Wait for Table Lock

Meaning:
Wait for exclusive TM enqueue in materialized view operations.

Optimization steps:
In the SAP environment, materialized views (Note 741478) are only implicitly used as standard when you carry out an online reorganization. Therefore, the “Wait for Table Lock” wait event generally only occurs in connection with an online reorganization. If you reorganize a table online and execute commands such as DBMS_REDEFINITION.START_REDEF_TABLE or DBMS_REDEFINITION.FINISH_REDEF_TABLE, and if another session simultaneously holds an exclusive TM enqueue (Note 745639) on the same table, the reorg session waits for “Wait for Table Lock”.

Therefore, this wait event only affects the runtime of reorganizations, and does not affect the production operation. You can reduce the number of times “Wait for Table Lock” occurs by not carrying out any other activities that set an exclusive TM enqueue at the same time as the online reorganization (also see Note 745639).

To check table indexes or anther data Dict was wrong.

Know issue
Bug 20111004 “COMMENT ON COLUMN” statement waits 1 second on “Wait for Table Lock”

打赏

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：