The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
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
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
abhiraj, October 17, 2017 - 6:26 am UTC
Share and learn SQL and PL/SQL; free access to the latest version of Oracle Database!
Classes, workouts and quizzes on Oracle Database technologies. Expertise through exercise!