Oracle

队列阻塞及描述

Posted by 道行尚浅 on July 12, 2015 
select ven.EVENT#,  
       ven.EVENT_ID,  
       ven.NAME,  
       ven.WAIT_CLASS_ID,  
       ven.WAIT_CLASS,  
       ves.EQ_NAME,  
       ves.EQ_TYPE,  
       ves.REQ_REASON,  
       ves.REQ_REASON  
  from v$event_name ven, v$enqueue_statistics ves  
 where ven.EVENT# = ves.EVENT#  
 order by ves.EQ_NAME
EVENT# EVENT_ID NAME WAIT_CLASS_ID WAIT_CLASS EQ_NAME EQ_TYPE REQ_REASON
1074 903153076 enq: FG - FG redo generation enq race 1893977003 Other ACD Relocation Gate Enqueue FG FG redo generation enq race
1073 1457820412 enq: FG - serialize ACD relocate 1893977003 Other ACD Relocation Gate Enqueue FG serialize ACD relocate
1075 3282679649 enq: FG - LGWR redo generation enq race 1893977003 Other ACD Relocation Gate Enqueue FG LGWR redo generation enq race
1080 642072527 enq: FX - issue ACD Xtnt Relocation CIC 1893977003 Other ACD Xtnt Info CIC FX issue ACD Xtnt Relocation CIC
959 798324601 enq: MH - contention 1893977003 Other AQ Notification Mail Host MH contention
960 4174613831 enq: ML - contention 1893977003 Other AQ Notification Mail Port ML contention
963 3111555168 enq: XH - contention 1893977003 Other AQ Notification No-Proxy XH contention
961 148033462 enq: PH - contention 1893977003 Other AQ Notification Proxy PH contention
962 3322341088 enq: SF - contention 1893977003 Other AQ Notification Sender SF contention
964 3791087697 enq: WA - contention 1893977003 Other AQ Notification Watermark WA contention
1103 3738539678 enq: KQ - access ASM attribute 1893977003 Other ASM Attributes Enque KQ access ASM attribute
1045 2372793991 enq: AD - relocate AU 1893977003 Other ASM Disk AU Lock AD relocate AU
1044 143335296 enq: AD - deallocate AU 1893977003 Other ASM Disk AU Lock AD deallocate AU
1043 2345563243 enq: AD - allocate AU 1893977003 Other ASM Disk AU Lock AD allocate AU
1054 685231043 enq: DG - contention 1893977003 Other ASM Disk Group Modification DG contention
1056 4039922119 enq: HD - contention 1893977003 Other ASM Disk Header HD contention
1049 1190657481 enq: DO - startup of MARK process 1893977003 Other ASM Disk Online Lock DO startup of MARK process
1048 3796486218 enq: DO - Staleness Registry create 1893977003 Other ASM Disk Online Lock DO Staleness Registry create
1047 3543159936 enq: DO - disk online recovery 1893977003 Other ASM Disk Online Lock DO disk online recovery
1046 1035436594 enq: DO - disk online 1893977003 Other ASM Disk Online Lock DO disk online
1050 329663708 enq: DO - disk online operation 1893977003 Other ASM Disk Online Lock DO disk online operation
1007 409056071 enq: AM - client registration 1893977003 Other ASM Enqueue AM client registration
1009 3718305 enq: AM - rollback COD reservation 1893977003 Other ASM Enqueue AM rollback COD reservation
1010 2163538166 enq: AM - background COD reservation 1893977003 Other ASM Enqueue AM background COD reservation
1011 2512559650 enq: AM - ASM cache freeze 1893977003 Other ASM Enqueue AM ASM cache freeze
1012 1784903832 enq: AM - ASM ACD Relocation 1893977003 Other ASM Enqueue AM ASM ACD Relocation
1013 3865222969 enq: AM - group use 1893977003 Other ASM Enqueue AM group use
1014 2069926448 enq: AM - group block 1893977003 Other ASM Enqueue AM group block
1015 827631834 enq: AM - ASM File Destroy 1893977003 Other ASM Enqueue AM ASM File Destroy
1016 1369527695 enq: AM - ASM User 1893977003 Other ASM Enqueue AM ASM User
1017 1010353447 enq: AM - ASM Password File Update 1893977003 Other ASM Enqueue AM ASM Password File Update
1018 2754586444 enq: AM - ASM Amdu Dump 1893977003 Other ASM Enqueue AM ASM Amdu Dump
1019 1111439585 enq: AM - disk offline 1893977003 Other ASM Enqueue AM disk offline
1020 1454769910 enq: AM - ASM reserved 1893977003 Other ASM Enqueue AM ASM reserved
1021 279744402 enq: AM - block repair 1893977003 Other ASM Enqueue AM block repair
1022 3396428008 enq: AM - ASM disk based alloc/dealloc 1893977003 Other ASM Enqueue AM ASM disk based alloc/dealloc
1023 3160612488 enq: AM - ASM file descriptor 1893977003 Other ASM Enqueue AM ASM file descriptor
1024 92719042 enq: AM - ASM file relocation 1893977003 Other ASM Enqueue AM ASM file relocation
1025 1063667893 enq: AM - ASM Grow ACD 1893977003 Other ASM Enqueue AM ASM Grow ACD
1008 4003623979 enq: AM - shutdown 1893977003 Other ASM Enqueue AM shutdown
1052 187881552 enq: XL - fault extent map 1893977003 Other ASM Extent Fault Lock XL fault extent map
1040 3051305468 enq: XQ - recovery 1893977003 Other ASM Extent Relocation Enqueue XQ recovery
1041 1688174401 enq: XQ - relocation 1893977003 Other ASM Extent Relocation Enqueue XQ relocation
1042 3970804539 enq: XQ - purification 1893977003 Other ASM Extent Relocation Enqueue XQ purification
1066 3415870113 enq: RX - unlock extent 1893977003 Other ASM Extent Relocation Lock RX unlock extent
1065 2145403328 enq: RX - relocate extent 1893977003 Other ASM Extent Relocation Lock RX relocate extent
1064 3182712926 enq: FA - access file 1893977003 Other ASM File Access Lock FA access file
1037 4186342174 enq: CM - gate 1893977003 Other ASM Instance Enqueue CM gate
1039 3457552864 enq: CM - diskgroup dismount 1893977003 Other ASM Instance Enqueue CM diskgroup dismount
1038 3394651275 enq: CM - instance 1893977003 Other ASM Instance Enqueue CM instance
1055 3688395675 enq: DD - contention 1893977003 Other ASM Local Disk Group DD contention
1085 1698021162 enq: PT - contention 1893977003 Other ASM Partnership and Status Table PT contention
1083 11871430 enq: RB - contention 1893977003 Other ASM Rollback Recovery RB contention
1107 3917752439 enq: AV - volume relocate 1893977003 Other ASM volume locks AV volume relocate
1106 1869608638 enq: AV - persistent DG number 1893977003 Other ASM volume locks AV persistent DG number
1109 845350487 enq: AV - add/enable first volume in DG 1893977003 Other ASM volume locks AV add/enable first volume in DG
1108 1293149770 enq: AV - AVD client registration 1893977003 Other ASM volume locks AV AVD client registration
1111 1641438405 enq: WF - contention 1893977003 Other AWR Flush WF contention
1112 2389341073 enq: WP - contention 1893977003 Other AWR Purge WP contention
1119 3691188946 enq: SH - contention 1893977003 Other Active Session History Flushing SH contention
1120 955173113 enq: AF - task serialization 1893977003 Other Advisor Framework AF task serialization
942 545059663 enq: AT - contention 1893977003 Other Alter Tablespace AT contention
996 3728184289 enq: AW - AW$ table lock 1893977003 Other Analytic Workspace AW AW$ table lock
997 2438512004 enq: AW - AW state lock 1893977003 Other Analytic Workspace AW AW state lock
998 541043045 enq: AW - user access for AW 1893977003 Other Analytic Workspace AW user access for AW
999 2247828282 enq: AW - AW generation lock 1893977003 Other Analytic Workspace AW AW generation lock
1000 2009316128 enq: AG - contention 1893977003 Other Analytic Workspace Generation AG contention
828 1444835457 enq: ZA - add std audit table partition 1893977003 Other Audit Partition ZA add std audit table partition
679 513503674 enq: AB - ABMR process start/stop 1893977003 Other Auto BMR AB ABMR process start/stop
680 4289089804 enq: AB - ABMR process initialized 1893977003 Other Auto BMR AB ABMR process initialized
1145 3791535926 enq: XD - ASM disk drop/add 1893977003 Other Auto Online Exadata disks XD ASM disk drop/add
1146 3849855823 enq: XD - ASM disk ONLINE 1893977003 Other Auto Online Exadata disks XD ASM disk ONLINE
1147 1707790998 enq: XD - ASM disk OFFLINE 1893977003 Other Auto Online Exadata disks XD ASM disk OFFLINE
1127 1739764420 enq: TK - Auto Task Slave Lockout 1893977003 Other Auto Task Serialization TK Auto Task Slave Lockout
1126 917975477 enq: TK - Auto Task Serialization 1893977003 Other Auto Task Serialization TK Auto Task Serialization
921 2476632936 enq: BF - PMON Join Filter cleanup 1893977003 Other BLOOM FILTER BF PMON Join Filter cleanup
920 2212717019 enq: BF - allocation contention 1893977003 Other BLOOM FILTER BF allocation contention
670 1785130586 enq: BR - multi-section restore header 1893977003 Other Backup/Restore BR multi-section restore header
668 3954034543 enq: BR - file shrink 1893977003 Other Backup/Restore BR file shrink
669 1796838767 enq: BR - proxy-copy 1893977003 Other Backup/Restore BR proxy-copy
671 1429048489 enq: BR - multi-section restore section 1893977003 Other Backup/Restore BR multi-section restore section
672 3146685455 enq: BR - space info datafile hdr update 1893977003 Other Backup/Restore BR space info datafile hdr update
673 4186138071 enq: BR - request autobackup 1893977003 Other Backup/Restore BR request autobackup
674 120917685 enq: BR - perform autobackup 1893977003 Other Backup/Restore BR perform autobackup
610 2704451831 enq: WL - Test access/locking 1893977003 Other Being Written Redo Log WL Test access/locking
649 1555037586 enq: WL - contention 1893977003 Other Being Written Redo Log WL contention
635 784686743 enq: WL - RFS global state contention 1893977003 Other Being Written Redo Log WL RFS global state contention
615 1710302097 enq: WL - RAC-wide SGA contention 1893977003 Other Being Written Redo Log WL RAC-wide SGA contention
706 2477507895 enq: CT - state change gate 2 1893977003 Other Block Change Tracking CT state change gate 2
704 2979034732 enq: CT - state 1893977003 Other Block Change Tracking CT state
705 790405879 enq: CT - state change gate 1 1893977003 Other Block Change Tracking CT state change gate 1
707 3488556206 enq: CT - CTWR process start/stop 1893977003 Other Block Change Tracking CT CTWR process start/stop
708 513540187 enq: CT - reading 1893977003 Other Block Change Tracking CT reading
701 1487467637 enq: CT - global space management 1893977003 Other Block Change Tracking CT global space management
703 690018733 enq: CT - change stream ownership 1893977003 Other Block Change Tracking CT change stream ownership
702 3466352936 enq: CT - local space management 1893977003 Other Block Change Tracking CT local space management
443 1272752883 enq: RE - block repair contention 1893977003 Other Block Repair/Resilvering RE block repair contention
86 3141712284 enq: PW - flush prewarm buffers 4217450380 Application Buffer Cache PreWarm PW flush prewarm buffers
590 1340848367 enq: PW - perwarm status in dbw0 1893977003 Other Buffer Cache PreWarm PW perwarm status in dbw0
450 2962754459 enq: CA - contention 1893977003 Other Calibration CA contention
945 4187088707 enq: CQ - contention 1893977003 Other Cleanup querycache registrations CQ contention
799 2630448508 enq: ZH - compression analysis 1893977003 Other Compression Analyzer ZH compression analysis
582 1494394835 enq: CF - contention 1893977003 Other Controlfile Transaction CF contention
425 1760863753 enq: CI - contention 1893977003 Other Cross-Instance Call Invocation CI contention
243 1435178951 enq: TW - contention 4166625743 Administrative Cross-Instance Transaction TW contention
816 325782660 enq: CU - contention 1893977003 Other Cursor CU contention
1113 2941830639 enq: FU - contention 1893977003 Other DBFUS FU contention
234 668627480 enq: TM - contention 4217450380 Application DML TM contention
977 770131870 enq: RF - synchronization: aifo master 1893977003 Other Data Guard Broker RF synchronization: aifo master
983 2311929058 enq: RF - FSFO Primary Shutdown suspended 1893977003 Other Data Guard Broker RF FSFO Primary Shutdown suspended
975 2609577957 enq: RF - synch: DG Broker metadata 1893977003 Other Data Guard Broker RF synch: DG Broker metadata
976 3779250430 enq: RF - atomicity 1893977003 Other Data Guard Broker RF atomicity
982 2735020950 enq: RF - DG Broker Current File ID 1893977003 Other Data Guard Broker RF DG Broker Current File ID
978 1283852695 enq: RF - new AI 1893977003 Other Data Guard Broker RF new AI
979 3573752690 enq: RF - synchronization: critical ai 1893977003 Other Data Guard Broker RF synchronization: critical ai
980 1173618054 enq: RF - RF - Database Automatic Disable 1893977003 Other Data Guard Broker RF RF - Database Automatic Disable
981 1422251130 enq: RF - FSFO Observer Heartbeat 1893977003 Other Data Guard Broker RF FSFO Observer Heartbeat
655 3294817508 enq: DM - contention 1893977003 Other Database Mount/Open DM contention
584 1608438935 enq: DS - contention 1893977003 Other Database Suspend DS contention
652 217146514 enq: DF - contention 1893977003 Other Datafile Online in RAC DF contention
314 3835660459 enq: DB - contention 4166625743 Administrative DbsDriver DB contention
777 319052581 enq: DT - contention 1893977003 Other Default Temporary Tablespace DT contention
803 2210508267 enq: DV - contention 1893977003 Other Diana Versioning DV contention
263 2908893972 enq: HV - contention 3875070507 Concurrency Direct Loader High Water Mark HV contention
792 1349347951 enq: DL - contention 1893977003 Other Direct Loader Index Creation DL contention
1078 1342373550 enq: FC - open an ACD thread 1893977003 Other Disk Group Chunk Mount FC open an ACD thread
1079 4041110320 enq: FC - recover an ACD thread 1893977003 Other Disk Group Chunk Mount FC recover an ACD thread
1072 2085113153 enq: FR - recover the thread 1893977003 Other Disk Group Recovery FR recover the thread
1070 1893664477 enq: FR - contention 1893977003 Other Disk Group Recovery FR contention
1071 3144887602 enq: FR - use the thread 1893977003 Other Disk Group Recovery FR use the thread
1077 3784147810 enq: FT - disable LGWR writes 1893977003 Other Disk Group Redo Generation FT disable LGWR writes
1076 4166969980 enq: FT - allow LGWR writes 1893977003 Other Disk Group Redo Generation FT allow LGWR writes
1057 2043768807 enq: DN - contention 1893977003 Other Diskgroup number generator DN contention
831 721778600 enq: DR - contention 1893977003 Other Distributed Recovery DR contention
830 2881503609 enq: DX - contention 1893977003 Other Distributed Transaction DX contention
817 3963940642 enq: AE - lock 1893977003 Other Edition Lock AE lock
823 4033490427 enq: OW - initialization 1893977003 Other Encryption Wallet OW initialization
824 964463181 enq: OW - termination 1893977003 Other Encryption Wallet OW termination
829 2473367936 enq: ZF - add fga audit table partition 1893977003 Other FGA Partition ZF add fga audit table partition
346 845337552 enq: ZG - contention 4166625743 Administrative File Group ZG contention
472 1830645796 enq: FM - contention 1893977003 Other File Mapping FM contention
442 3750685624 enq: FP - global fob contention 1893977003 Other File Object FP global fob contention
654 1309055815 enq: FS - contention 1893977003 Other File Set / Dictionary Check FS contention
727 2085703061 enq: FD - Flashback logical operations 1893977003 Other Flashback Database FD Flashback logical operations
726 795831746 enq: FD - Restore point create/drop 1893977003 Other Flashback Database FD Restore point create/drop
722 1057119651 enq: FD - Marker generation 1893977003 Other Flashback Database FD Marker generation
723 120716488 enq: FD - Tablespace flashback on/off 1893977003 Other Flashback Database FD Tablespace flashback on/off
725 1783985711 enq: FD - Flashback on/off 1893977003 Other Flashback Database FD Flashback on/off
724 3377895670 enq: FD - Flashback coordinator 1893977003 Other Flashback Database FD Flashback coordinator
721 511900941 enq: FL - Flashback db command 1893977003 Other Flashback database log FL Flashback db command
720 3383573524 enq: FL - Flashback database log 1893977003 Other Flashback database log FL Flashback database log
779 1238611814 enq: FB - contention 1893977003 Other Format Block FB contention
827 1248642937 enq: ZZ - update hash tables 1893977003 Other Global Context Action ZZ update hash tables
432 925144608 enq: PG - contention 1893977003 Other Global Parameter PG contention
283 3304404527 enq: BB - 2PC across RAC instances 3386400367 Commit Global Transaction Branch BB 2PC across RAC instances
793 403868930 enq: HQ - contention 1893977003 Other Hash Queue HQ contention
781 2910919470 enq: DW - contention 1893977003 Other In memory Dispenser DW contention
919 2239268215 enq: IT - contention 1893977003 Other In-Mem Temp Table Meta Creation IT contention
661 3041521765 enq: IR - contention2 1893977003 Other Instance Recovery IR contention2
660 4021392840 enq: IR - contention 1893977003 Other Instance Recovery IR contention
653 1184948750 enq: IS - contention 1893977003 Other Instance State IS contention
750 2605232529 enq: TA - contention 1893977003 Other Instance Undo TA contention
939 2673474179 enq: IA - contention 1893977003 Other Internal IA contention
473 107371275 enq: XY - contention 1893977003 Other Internal Test XY contention
878 4077422893 enq: JQ - contention 1893977003 Other Job Queue JQ contention
877 2016557033 enq: JD - contention 1893977003 Other Job Queue Date JD contention
1142 3418411601 enq: JS - wdw op 1893977003 Other Job Scheduler JS wdw op
1141 4064242319 enq: JS - evtsub drop 1893977003 Other Job Scheduler JS evtsub drop
1134 3797524291 enq: JS - contention 1893977003 Other Job Scheduler JS contention
1139 1053495082 enq: JS - q mem clnup lck 1893977003 Other Job Scheduler JS q mem clnup lck
1138 1430268372 enq: JS - sch locl enqs 1893977003 Other Job Scheduler JS sch locl enqs
1137 306423829 enq: JS - queue lock 1893977003 Other Job Scheduler JS queue lock
1136 1043516589 enq: JS - job recov lock 1893977003 Other Job Scheduler JS job recov lock
1135 6961751 enq: JS - job run lock - synchronize 1893977003 Other Job Scheduler JS job run lock - synchronize
1143 3478457902 enq: JS - evt notify 1893977003 Other Job Scheduler JS evt notify
1144 903782161 enq: JS - aq sync 1893977003 Other Job Scheduler JS aq sync
1140 551173053 enq: JS - evtsub add 1893977003 Other Job Scheduler JS evtsub add
458 2894614381 enq: PV - syncshut 1893977003 Other KSV slave startup PV syncshut
457 3063016909 enq: PV - syncstart 1893977003 Other KSV slave startup PV syncstart
917 3076848514 enq: AY - contention 1893977003 Other KSXA Test Affinity Dictionary AY contention
760 4060759714 enq: CN - race with reg 1893977003 Other KTCN REG enq CN race with reg
759 706934628 enq: CN - race with txn 1893977003 Other KTCN REG enq CN race with txn
761 613420004 enq: CN - race with init 1893977003 Other KTCN REG enq CN race with init
758 4241032297 enq: TE - KTF broadcast 1893977003 Other KTF broadcast TE KTF broadcast
757 1752153790 enq: TD - KTF dump entries 1893977003 Other KTF map table enqueue TD KTF dump entries
764 3932945957 enq: FE - contention 1893977003 Other KTFA Recovery FE contention
786 887351382 enq: SJ - Slave Task Cancel 1893977003 Other KTSJ Slave Task Cancel SJ Slave Task Cancel
763 606473003 enq: CO - master slave det 1893977003 Other KTUCLO Master Slave enq CO master slave det
756 2301151944 enq: IM - contention for blr 1893977003 Other Kti blr lock IM contention for blr
929 4149771879 enq: KP - contention 1893977003 Other Kupp Process Startup KP contention
958 1150705222 enq: DP - contention 1893977003 Other LDAP Parameter DP contention
645 1211302889 enq: WR - contention 1893977003 Other LNS archiving log WR contention
819 1682769842 enq: IL - contention 1893977003 Other Label Security IL contention
821 3032662556 enq: CL - compare labels 1893977003 Other Label Security cache CL compare labels
820 1619270516 enq: CL - drop label 1893977003 Other Label Security cache CL drop label
1124 2407027636 enq: TL - contention 1893977003 Other Log Lock TL contention
683 1489162918 enq: MN - contention 1893977003 Other LogMiner MN contention
685 260587712 enq: SB - logical standby metadata 1893977003 Other LogicalStandby SB logical standby metadata
686 2514944057 enq: SB - table instantiation 1893977003 Other LogicalStandby SB table instantiation
1123 3932123875 enq: MO - contention 1893977003 Other MMON restricted session MO contention
1114 3384888932 enq: MW - contention 1893977003 Other MWIN Schedule MW contention
822 3559219295 enq: MK - contention 1893977003 Other Master Key MK contention
940 2959147725 enq: JI - contention 1893977003 Other Materialized View JI contention
806 1305530676 enq: RW - MV metadata contention 1893977003 Other Materialized View Flags RW MV metadata contention
884 3735259588 enq: MD - contention 1893977003 Other Materialized View Log DDL MD contention
885 3982742587 enq: MS - contention 1893977003 Other Materialized View Refresh Log MS contention
663 3480024039 enq: MR - standby role transition 1893977003 Other Media Recovery MR standby role transition
662 3113891348 enq: MR - contention 1893977003 Other Media Recovery MR contention
1001 2454416615 enq: AO - contention 1893977003 Other MultiWriter Object Access AO contention
108 4205197519 enq: KO - fast object checkpoint 4217450380 Application Multiple Object Checkpoint KO fast object checkpoint
106 3500532018 enq: RO - contention 4217450380 Application Multiple Object Reuse RO contention
107 143262751 enq: RO - fast object reuse 4217450380 Application Multiple Object Reuse RO fast object reuse
675 4055016213 enq: ID - contention 1893977003 Other NID ID contention
1006 4194119705 enq: OQ - xsoqhistrecb 1893977003 Other OLAPI Histories OQ xsoqhistrecb
1003 3682185722 enq: OQ - xsoqhiFlush 1893977003 Other OLAPI Histories OQ xsoqhiFlush
1004 681553729 enq: OQ - xsoq*histrecb 1893977003 Other OLAPI Histories OQ xsoq*histrecb
1005 2148426979 enq: OQ - xsoqhiClose 1893977003 Other OLAPI Histories OQ xsoqhiClose
1002 523388040 enq: OQ - xsoqhiAlloc 1893977003 Other OLAPI Histories OQ xsoqhiAlloc
879 143199788 enq: OD - Serializing DDLs 1893977003 Other Online DDLs OD Serializing DDLs
152 1567037747 enq: MV - datafile move 4166625743 Administrative Online Datafile Move MV datafile move
807 1911278064 enq: OC - contention 1893977003 Other Outline Cache OC contention
808 3443769614 enq: OL - contention 1893977003 Other Outline Name OL contention
907 2071012023 enq: PS - contention 1893977003 Other PX Process Reservation PS contention
431 4129138703 enq: PE - contention 1893977003 Other Parameter PE contention
818 2211137592 enq: PF - contention 1893977003 Other Password File PF contention
426 3733307663 enq: PR - contention 1893977003 Other Process Startup PR contention
477 245034220 enq: PD - contention 1893977003 Other Property Lock PD contention
794 893937616 enq: HP - contention 1893977003 Other Queue Page HP contention
956 3544909312 enq: TQ - DDL-INI contention 1893977003 Other Queue table enqueue TQ DDL-INI contention
954 717240345 enq: TQ - DDL contention 1893977003 Other Queue table enqueue TQ DDL contention
953 1371132976 enq: TQ - TM contention 1893977003 Other Queue table enqueue TQ TM contention
955 451597502 enq: TQ - INI contention 1893977003 Other Queue table enqueue TQ INI contention
694 3609173507 enq: XR - database force logging 1893977003 Other Quiesce / Force Logging XR database force logging
693 707813539 enq: XR - quiesce database 1893977003 Other Quiesce / Force Logging XR quiesce database
826 2687533677 enq: RL - RAC wallet lock 1893977003 Other RAC Encryption Wallet Lock RL RAC wallet lock
922 3612504684 enq: RD - RAC load 1893977003 Other RAC Load RD RAC load
717 3178040924 enq: RS - persist alert level 1893977003 Other Reclaimable Space RS persist alert level
714 313351369 enq: RS - record reuse 1893977003 Other Reclaimable Space RS record reuse
716 3170569251 enq: RS - prevent aging list update 1893977003 Other Reclaimable Space RS prevent aging list update
715 3504071695 enq: RS - prevent file delete 1893977003 Other Reclaimable Space RS prevent file delete
713 2897929244 enq: RS - file delete 1893977003 Other Reclaimable Space RS file delete
719 3488540422 enq: RS - write alert level 1893977003 Other Reclaimable Space RS write alert level
718 115643876 enq: RS - read alert level 1893977003 Other Reclaimable Space RS read alert level
650 1281359820 enq: RN - contention 1893977003 Other Redo Log Nab Computation RN contention
659 2588100800 enq: RT - thread internal enable/disable 1893977003 Other Redo Thread RT thread internal enable/disable
658 1143317824 enq: RT - contention 1893977003 Other Redo Thread RT contention
906 2143046196 enq: PI - contention 1893977003 Other Remote PX Process Spawn Status PI contention
656 647852263 enq: RP - contention 1893977003 Other Resilver / Repair RP contention
331 2649722911 enq: RC - Result Cache: Contention 4217450380 Application Result Cache: Enqueue RC Result Cache: Contention
605 2576559565 enq: CR - block range reuse ckpt 1893977003 Other Reuse Block Range CR block range reuse ckpt
479 3530171172 enq: RU - contention 1893977003 Other Rolling Migration RU contention
480 2020359573 enq: RU - waiting 1893977003 Other Rolling Migration RU waiting
805 3937527428 enq: TP - contention 1893977003 Other Runtime Fixed Table Purge TP contention
887 197381757 enq: AP - contention 1893977003 Other SPM Autopurge AP contention
332 1636695715 enq: JX - SQL statement queue 2396326234 Scheduler SQL STATEMENT QUEUE JX SQL statement queue
333 3822543692 enq: JX - cleanup of queue 2396326234 Scheduler SQL STATEMENT QUEUE JX cleanup of queue
1118 2878002362 enq: TB - SQL Tuning Base Cache Load 1893977003 Other SQL Tuning Base Existence Cache TB SQL Tuning Base Cache Load
1117 3315745697 enq: TB - SQL Tuning Base Cache Update 1893977003 Other SQL Tuning Base Existence Cache TB SQL Tuning Base Cache Update
782 3652428359 enq: SU - contention 1893977003 Other SaveUndo Segment SU contention
448 1504129838 enq: KM - contention 1893977003 Other Scheduler KM contention
451 2775294757 enq: KD - determine DBRM master 1893977003 Other Scheduler Master DBRM KD determine DBRM master
449 1301289702 enq: KT - contention 1893977003 Other Scheduler Plan KT contention
253 1645217925 enq: HW - contention 3290255840 Configuration Segment High Water Mark HW contention
259 2322460838 enq: SQ - contention 3290255840 Configuration Sequence Cache SQ contention
797 1973889364 enq: SL - escalate lock 1893977003 Other Serialize Lock request SL escalate lock
796 3380482012 enq: SL - get lock 1893977003 Other Serialize Lock request SL get lock
798 3555038872 enq: SL - get lock for undo 1893977003 Other Serialize Lock request SL get lock for undo
476 2558928434 enq: AS - service activation 1893977003 Other Service Operations AS service activation
950 3429311972 enq: SE - contention 1893977003 Other Session Migration SE contention
804 2584404246 enq: SO - contention 1893977003 Other Shared Object SO contention
780 2678203686 enq: SK - contention 1893977003 Other Shrink Segment SK contention
254 3890744969 enq: SS - contention 3290255840 Configuration Sort Segment SS contention
235 1649608974 enq: ST - contention 3290255840 Configuration Space Transaction ST contention
461 839059449 enq: SP - contention 3 1893977003 Other Spare Enqueue SP contention 3
459 980653535 enq: SP - contention 1 1893977003 Other Spare Enqueue SP contention 1
460 351221043 enq: SP - contention 2 1893977003 Other Spare Enqueue SP contention 2
462 1340803846 enq: SP - contention 4 1893977003 Other Spare Enqueue SP contention 4
937 3398735787 enq: SI - contention 1893977003 Other Streams Table Instantiation SI contention
583 608373385 enq: SW - contention 1893977003 Other Suspend Writes SW contention
934 3056899600 enq: SR - contention 1893977003 Other Synchronized Replication SR contention
970 389396261 enq: OT - TEXT: Generic Lock 1893977003 Other TEXT: Generic Lock OT TEXT: Generic Lock
969 4107448082 enq: CX - TEXT: Index Specific Lock 1893977003 Other TEXT: Index Specific Lock CX TEXT: Index Specific Lock
783 4205956891 enq: TT - contention 1893977003 Other Tablespace TT contention
586 718572278 enq: TC - contention2 1893977003 Other Tablespace Checkpoint TC contention2
585 1231322525 enq: TC - contention 1893977003 Other Tablespace Checkpoint TC contention
918 3701540314 enq: TO - contention 1893977003 Other Temp Object TO contention
766 896842959 enq: TF - contention 1893977003 Other Temporary File TF contention
778 2667616873 enq: TS - contention 1893977003 Other Temporary Segment TS contention
1125 3243557671 enq: TH - metric threshold evaluation 1893977003 Other Threshold Chain TH metric threshold evaluation
240 310662678 enq: TX - row lock contention 4217450380 Application Transaction TX row lock contention
241 281768874 enq: TX - allocate ITL entry 3290255840 Configuration Transaction TX allocate ITL entry
242 1035026728 enq: TX - index contention 3875070507 Concurrency Transaction TX index contention
751 1629782133 enq: TX - contention 1893977003 Other Transaction TX contention
684 622794581 enq: PL - contention 1893977003 Other Transportable Tablespace PL contention
752 2458904239 enq: US - contention 1893977003 Other Undo Segment US contention
367 738183602 enq: UL - contention 4217450380 Application User-defined UL contention
409 2390244800 enq: WM - WLM Plan activation 1893977003 Other WLM Plan Operations WM WLM Plan activation
1128 2152050500 enq: RR - contention 1893977003 Other Workload Capture and Replay RR contention
795 3445676385 enq: WG - delete fso 1893977003 Other Write gather local enqueue WG delete fso
272 122034066 enq: WG - lock fso 3875070507 Concurrency Write gather local enqueue WG lock fso
972 300221745 enq: XC - XDB Configuration 1893977003 Other XDB Configuration XC XDB Configuration
444 3396302007 enq: BM - clonedb bitmap file write 1893977003 Other clonedb bitmap file access BM clonedb bitmap file write
484 1933295843 enq: MX - sync storage server info 1893977003 Other ksz synch MX sync storage server info
825 3147636141 enq: RK - set key 1893977003 Other wallet_set_mkey RK set key