Skip to Main Content
  • Questions
  • When are these wait event occur and what are the causes enq: IM - contention for blr and enq: TA - contention

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, abhiraj.

Asked: January 31, 2017 - 8:45 am UTC

Last updated: October 17, 2017 - 3:34 pm UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

When are these wait event occur and what are the causes and solutions for them.
1) enq: IM - contention for blr
2) enq: TA - contention
3) undo segment tx slot

and Connor said...

V$LOCK_TYPE is a cool view for enqueue

SQL> select * from v$lock_type
  2  where type in ( 'IM','TA')
  3  @pr
==============================
TYPE                          : TA
NAME                          : Instance Undo
ID1_TAG                       : operation
ID2_TAG                       : undo segment # / other
IS_USER                       : NO
IS_RECYCLE                    : NO
DESCRIPTION                   : Serializes operations on undo segments and undo tablespaces
CON_ID                        : 0
==============================
TYPE                          : IM
NAME                          : Kti blr lock
ID1_TAG                       : pool #
ID2_TAG                       : 0
IS_USER                       : NO
IS_RECYCLE                    : NO
DESCRIPTION                   : Serializes block recovery for an IMU txn
CON_ID                        : 0



and the last one is in the docs

https://docs.oracle.com/database/121/REFRN/GUID-758BA52A-B707-4958-AA45-2075D74402F2.htm#REFRN00649

A 'tx' slot is an entry in the undo segment required to commence a transaction.

So without making too many assumptions on *why* you have asked the question, it perhaps suggests you've got a lot of concurrent transactions going on ?

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Hidden parameters

abhiraj, October 17, 2017 - 6:26 am UTC


Are the below parameters set could cause issues in the database?

And what are the issues with them.?

_always_anti_join :off
_always_semi_join : off
_disk_sector_size_override :TRUE
_hash_join_enabled: FALSEĀ 
_kgl_large_heap_warning_threshold : 204857600