My Oracle Support Banner

Threads Hanging Under High Volume (Doc ID 2530929.1)

Last updated on OCTOBER 03, 2019

Applies to:

Oracle Documaker - Version 12.6 and later
Information in this document applies to any platform.

Symptoms

Following information from the DBA team:


Database analysis and finding

We were able to see that, below query got locked for more time.

DELETE FROM APPTEMP_TBL_REF ApptempTblRefEO WHERE ApptempTblRefEO.Tid = :1

• As per database report, found that table lock happened on DMKR_FCORR.SELECTED_INFO table. This table has foreign key with DMKR_FCORR.ATTACHMENTS. And, DMKR_FCORR.ATTACHMENTS has foreign key with APPTEMP_TBL_REF table. It looks, foreign key chaining causing the locking issues. while deleting record on APPTEMP_TBL_REF table, it checks for all table dependencies. Due to table lock, deletes are waiting for longer time.

Finding 2: Table Locks
Impact is .63 active sessions, 88.54% of total activity.
--------------------------------------------------------
Contention on table lock waits was consuming significant database time.

  Recommendation 1: Application Analysis
  Estimated benefit is .63 active sessions, 88.54% of total activity.
  -------------------------------------------------------------------
  Action
  Investigate application logic involving DDL and DML on provided blocked  objects.
  Rationale
  The database object with object ID "114016" was locked for a significant   time.
  Related Object
  Database object with ID 114016.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.