队列阻塞及描述

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_IDNAMEWAIT_CLASS_IDWAIT_CLASSEQ_NAMEEQ_TYPEREQ_REASONREQ_REASON8623282679649enq: FG - LGWR redo generation enq race1893977003OtherACD Relocation Gate EnqueueFGLGWR redo generation enq raceLGWR redo generation enq race861903153076enq: FG - FG redo generation enq race1893977003OtherACD Relocation Gate EnqueueFGFG redo generation enq raceFG redo generation enq race8601457820412enq: FG - serialize ACD relocate1893977003OtherACD Relocation Gate EnqueueFGserialize ACD relocateserialize ACD relocate735798324601enq: MH - contention1893977003OtherAQ Notification Mail HostMHcontentioncontention7364174613831enq: ML - contention1893977003OtherAQ Notification Mail PortMLcontentioncontention7393111555168enq: XH - contention1893977003OtherAQ Notification No-ProxyXHcontentioncontention737148033462enq: PH - contention1893977003OtherAQ Notification ProxyPHcontentioncontention7383322341088enq: SF - contention1893977003OtherAQ Notification SenderSFcontentioncontention7403791087697enq: WA - contention1893977003OtherAQ Notification WatermarkWAcontentioncontention8412345563243enq: AD - allocate AU1893977003OtherASM Disk AU LockADallocate AUallocate AU842143335296enq: AD - deallocate AU1893977003OtherASM Disk AU LockADdeallocate AUdeallocate AU845685231043enq: DG - contention1893977003OtherASM Disk Group ModificationDGcontentioncontention8474039922119enq: HD - contention1893977003OtherASM Disk HeaderHDcontentioncontention8254003623979enq: AM - shutdown1893977003OtherASM EnqueueAMshutdownshutdown824409056071enq: AM - client registration1893977003OtherASM EnqueueAMclient registrationclient registration8263718305enq: AM - rollback COD reservation1893977003OtherASM EnqueueAMrollback COD reservationrollback COD reservation827827631834enq: AM - ASM File Destroy1893977003OtherASM EnqueueAMASM File DestroyASM File Destroy8401688174401enq: XQ - relocation1893977003OtherASM Extent Relocation EnqueueXQrelocationrelocation8393051305468enq: XQ - recovery1893977003OtherASM Extent Relocation EnqueueXQrecoveryrecovery8553182712926enq: FA - access file1893977003OtherASM File Access LockFAaccess fileaccess file8374186342174enq: CM - gate1893977003OtherASM Instance EnqueueCMgategate8383394651275enq: CM - instance1893977003OtherASM Instance EnqueueCMinstanceinstance8463688395675enq: DD - contention1893977003OtherASM Local Disk GroupDDcontentioncontention8701698021162enq: PT - contention1893977003OtherASM Partnership and Status TablePTcontentioncontention86911871430enq: RB - contention1893977003OtherASM Rollback RecoveryRBcontentioncontention8871641438405enq: WF - contention1893977003OtherAWR FlushWFcontentioncontention8882389341073enq: WP - contention1893977003OtherAWR PurgeWPcontentioncontention8953691188946enq: SH - contention1893977003OtherActive Session History FlushingSHcontentioncontention896955173113enq: AF - task serialization1893977003OtherAdvisor FrameworkAFtask serializationtask serialization723545059663enq: AT - contention1893977003OtherAlter TablespaceATcontentioncontention815541043045enq: AW - user access for AW1893977003OtherAnalytic WorkspaceAWuser access for AWuser access for AW8162247828282enq: AW - AW generation lock1893977003OtherAnalytic WorkspaceAWAW generation lockAW generation lock8133728184289enq: AW - AW$ table lock1893977003OtherAnalytic WorkspaceAWAW$ table lockAW$ table lock8142438512004enq: AW - AW state lock1893977003OtherAnalytic WorkspaceAWAW state lockAW state lock8172009316128enq: AG - contention1893977003OtherAnalytic Workspace GenerationAGcontentioncontention6381444835457enq: ZA - add std audit table partition1893977003OtherAudit PartitionZAadd std audit table partitionadd std audit table partition6371704200513enq: AU - audit index file1893977003OtherAudit index fileAUaudit index fileaudit index file7042212717019enq: BF - allocation contention1893977003OtherBLOOM FILTERBFallocation contentionallocation contention7052476632936enq: BF - PMON Join Filter cleanup1893977003OtherBLOOM FILTERBFPMON Join Filter cleanupPMON Join Filter cleanup5201796838767enq: BR - proxy-copy1893977003OtherBackup/RestoreBRproxy-copyproxy-copy5193954034543enq: BR - file shrink1893977003OtherBackup/RestoreBRfile shrinkfile shrink5051555037586enq: WL - contention1893977003OtherBeing Written Redo LogWLcontentioncontention5413488556206enq: CT - CTWR process start/stop1893977003OtherBlock Change TrackingCTCTWR process start/stopCTWR process start/stop542513540187enq: CT - reading1893977003OtherBlock Change TrackingCTreadingreading5402477507895enq: CT - state change gate 21893977003OtherBlock Change TrackingCTstate change gate 2state change gate 25351487467637enq: CT - global space management1893977003OtherBlock Change TrackingCTglobal space managementglobal space management539790405879enq: CT - state change gate 11893977003OtherBlock Change TrackingCTstate change gate 1state change gate 15382979034732enq: CT - state1893977003OtherBlock Change TrackingCTstatestate537690018733enq: CT - change stream ownership1893977003OtherBlock Change TrackingCTchange stream ownershipchange stream ownership5363466352936enq: CT - local space management1893977003OtherBlock Change TrackingCTlocal space managementlocal space management593141712284enq: PW - flush prewarm buffers4217450380ApplicationBuffer Cache PreWarmPWflush prewarm buffersflush prewarm buffers4451340848367enq: PW - perwarm status in dbw01893977003OtherBuffer Cache PreWarmPWperwarm status in dbw0perwarm status in dbw04361494394835enq: CF - contention1893977003OtherControlfile TransactionCFcontentioncontention3101760863753enq: CI - contention1893977003OtherCross-Instance Call InvocationCIcontentioncontention1911435178951enq: TW - contention4166625743AdministrativeCross-Instance TransactionTWcontentioncontention627325782660enq: CU - contention1893977003OtherCursorCUcontentioncontention8892941830639enq: FU - contention1893977003OtherDBFUSFUcontentioncontention180668627480enq: TM - contention4217450380ApplicationDMLTMcontentioncontention776770131870enq: RF - synchronization: aifo master1893977003OtherData Guard BrokerRFsynchronization: aifo mastersynchronization: aifo master7803366829177enq: RF - RF - FSFO wait1893977003OtherData Guard BrokerRFRF - FSFO waitRF - FSFO wait7722609577957enq: RF - synch: DG Broker metadata1893977003OtherData Guard BrokerRFsynch: DG Broker metadatasynch: DG Broker metadata7733779250430enq: RF - atomicity1893977003OtherData Guard BrokerRFatomicityatomicity7743003004322enq: RF - synchronization: chief1893977003OtherData Guard BrokerRFsynchronization: chiefsynchronization: chief775606072730enq: RF - synchronization: HC master1893977003OtherData Guard BrokerRFsynchronization: HC mastersynchronization: HC master7792279551044enq: RF - RF - FSFO state1893977003OtherData Guard BrokerRFRF - FSFO stateRF - FSFO state7771283852695enq: RF - new AI1893977003OtherData Guard BrokerRFnew AInew AI7783573752690enq: RF - synchronization: critical ai1893977003OtherData Guard BrokerRFsynchronization: critical aisynchronization: critical ai7841173618054enq: RF - RF - Database Automatic Disable1893977003OtherData Guard BrokerRFRF - Database Automatic DisableRF - Database Automatic Disable7831428020024enq: RF - RF - FSFO Observed1893977003OtherData Guard BrokerRFRF - FSFO ObservedRF - FSFO Observed7823458076230enq: RF - RF - FSFO synchronization1893977003OtherData Guard BrokerRFRF - FSFO synchronizationRF - FSFO synchronization7813605725689enq: RF - RF - FSFO connectivity1893977003OtherData Guard BrokerRFRF - FSFO connectivityRF - FSFO connectivity5113294817508enq: DM - contention1893977003OtherDatabase Mount/OpenDMcontentioncontention4381608438935enq: DS - contention1893977003OtherDatabase SuspendDScontentioncontention508217146514enq: DF - contention1893977003OtherDatafile Online in RACDFcontentioncontention2393835660459enq: DB - contention4166625743AdministrativeDbsDriverDBcontentioncontention579319052581enq: DT - contention1893977003OtherDefault Temporary TablespaceDTcontentioncontention6162210508267enq: DV - contention1893977003OtherDiana VersioningDVcontentioncontention6092908893972enq: HV - contention1893977003OtherDirect Loader High Water MarkHVcontentioncontention6131349347951enq: DL - contention1893977003OtherDirect Loader Index CreationDLcontentioncontention8664041110320enq: FC - recover an ACD thread1893977003OtherDisk Group Chunk MountFCrecover an ACD threadrecover an ACD thread8651342373550enq: FC - open an ACD thread1893977003OtherDisk Group Chunk MountFCopen an ACD threadopen an ACD thread8591893664477enq: FR - contention1893977003OtherDisk Group RecoveryFRcontentioncontention8634166969980enq: FT - allow LGWR writes1893977003OtherDisk Group Redo GenerationFTallow LGWR writesallow LGWR writes8643784147810enq: FT - disable LGWR writes1893977003OtherDisk Group Redo GenerationFTdisable LGWR writesdisable LGWR writes8482043768807enq: DN - contention1893977003OtherDiskgroup number generatorDNcontentioncontention641721778600enq: DR - contention1893977003OtherDistributed RecoveryDRcontentioncontention6402881503609enq: DX - contention1893977003OtherDistributed TransactionDXcontentioncontention6354033490427enq: OW - initialization1893977003OtherEncryption WalletOWinitializationinitialization636964463181enq: OW - termination1893977003OtherEncryption WalletOWterminationtermination6392473367936enq: ZF - add fga audit table partition1893977003OtherFGA PartitionZFadd fga audit table partitionadd fga audit table partition257845337552enq: ZG - contention4166625743AdministrativeFile GroupZGcontentioncontention3481830645796enq: FM - contention1893977003OtherFile MappingFMcontentioncontention3273750685624enq: FP - global fob contention1893977003OtherFile ObjectFPglobal fob contentionglobal fob contention5101309055815enq: FS - contention1893977003OtherFile Set / Dictionary CheckFScontentioncontention561795831746enq: FD - Restore point create/drop1893977003OtherFlashback DatabaseFDRestore point create/dropRestore point create/drop5601783985711enq: FD - Flashback on/off1893977003OtherFlashback DatabaseFDFlashback on/offFlashback on/off5571057119651enq: FD - Marker generation1893977003OtherFlashback DatabaseFDMarker generationMarker generation558120716488enq: FD - Tablespace flashback on/off1893977003OtherFlashback DatabaseFDTablespace flashback on/offTablespace flashback on/off5593377895670enq: FD - Flashback coordinator1893977003OtherFlashback DatabaseFDFlashback coordinatorFlashback coordinator556511900941enq: FL - Flashback db command1893977003OtherFlashback database logFLFlashback db commandFlashback db command5553383573524enq: FL - Flashback database log1893977003OtherFlashback database logFLFlashback database logFlashback database log5811238611814enq: FB - contention1893977003OtherFormat BlockFBcontentioncontention317925144608enq: PG - contention1893977003OtherGlobal ParameterPGcontentioncontention614403868930enq: HQ - contention1893977003OtherHash QueueHQcontentioncontention7032239268215enq: IT - contention1893977003OtherIn-Mem Temp Table Meta CreationITcontentioncontention5164021392840enq: IR - contention1893977003OtherInstance RecoveryIRcontentioncontention5173041521765enq: IR - contention21893977003OtherInstance RecoveryIRcontention2contention25091184948750enq: IS - contention1893977003OtherInstance StateIScontentioncontention5912605232529enq: TA - contention1893977003OtherInstance UndoTAcontentioncontention7202673474179enq: IA - contention1893977003OtherInternalIAcontentioncontention349107371275enq: XY - contention1893977003OtherInternal TestXYcontentioncontention6734077422893enq: JQ - contention1893977003OtherJob QueueJQcontentioncontention6722016557033enq: JD - contention1893977003OtherJob Queue DateJDcontentioncontention9143478457902enq: JS - evt notify1893977003OtherJob SchedulerJSevt notifyevt notify9133418411601enq: JS - wdw op1893977003OtherJob SchedulerJSwdw opwdw op9124064242319enq: JS - evtsub drop1893977003OtherJob SchedulerJSevtsub dropevtsub drop911551173053enq: JS - evtsub add1893977003OtherJob SchedulerJSevtsub addevtsub add9101053495082enq: JS - q mem clnup lck1893977003OtherJob SchedulerJSq mem clnup lckq mem clnup lck9091430268372enq: JS - sch locl enqs1893977003OtherJob SchedulerJSsch locl enqssch locl enqs908306423829enq: JS - queue lock1893977003OtherJob SchedulerJSqueue lockqueue lock9071043516589enq: JS - job recov lock1893977003OtherJob SchedulerJSjob recov lockjob recov lock9066961751enq: JS - job run lock - synchronize1893977003OtherJob SchedulerJSjob run lock - synchronizejob run lock - synchronize9053797524291enq: JS - contention1893977003OtherJob SchedulerJScontentioncontention3352894614381enq: PV - syncshut1893977003OtherKSV slave startupPVsyncshutsyncshut3343063016909enq: PV - syncstart1893977003OtherKSV slave startupPVsyncstartsyncstart604706934628enq: CN - race with txn1893977003OtherKTCN REG enqCNrace with txnrace with txn6054060759714enq: CN - race with reg1893977003OtherKTCN REG enqCNrace with regrace with reg606613420004enq: CN - race with init1893977003OtherKTCN REG enqCNrace with initrace with init6034241032297enq: TE - KTF broadcast1893977003OtherKTF broadcastTEKTF broadcastKTF broadcast6021752153790enq: TD - KTF dump entries1893977003OtherKTF map table enqueueTDKTF dump entriesKTF dump entries515143032950enq: KK - context1893977003OtherKick Instance to Switch LogsKKcontextcontext6012301151944enq: IM - contention for blr1893977003OtherKti blr lockIMcontention for blrcontention for blr7104149771879enq: KP - contention1893977003OtherKupp Process StartupKPcontentioncontention7341150705222enq: DP - contention1893977003OtherLDAP ParameterDPcontentioncontention4591211302889enq: WR - contention1893977003OtherLNS archiving logWRcontentioncontention6311682769842enq: IL - contention1893977003OtherLabel SecurityILcontentioncontention6333032662556enq: CL - compare labels1893977003OtherLabel Security cacheCLcompare labelscompare labels6321619270516enq: CL - drop label1893977003OtherLabel Security cacheCLdrop labeldrop label9002407027636enq: TL - contention1893977003OtherLog LockTLcontentioncontention5221489162918enq: MN - contention1893977003OtherLogMinerMNcontentioncontention5282727448356enq: SB - contention1893977003OtherLogicalStandbySBcontentioncontention8993932123875enq: MO - contention1893977003OtherMMON restricted sessionMOcontentioncontention8903384888932enq: MW - contention1893977003OtherMWIN ScheduleMWcontentioncontention6343559219295enq: MK - contention1893977003OtherMaster KeyMKcontentioncontention7212959147725enq: JI - contention1893977003OtherMaterialized ViewJIcontentioncontention6171305530676enq: RW - MV metadata contention1893977003OtherMaterialized View FlagsRWMV metadata contentionMV metadata contention6773735259588enq: MD - contention1893977003OtherMaterialized View Log DDLMDcontentioncontention6783982742587enq: MS - contention1893977003OtherMaterialized View Refresh LogMScontentioncontention5183113891348enq: MR - contention1893977003OtherMedia RecoveryMRcontentioncontention8182454416615enq: AO - contention1893977003OtherMultiWriter Object AccessAOcontentioncontention754205197519enq: KO - fast object checkpoint4217450380ApplicationMultiple Object CheckpointKOfast object checkpointfast object checkpoint74143262751enq: RO - fast object reuse4217450380ApplicationMultiple Object ReuseROfast object reusefast object reuse733500532018enq: RO - contention4217450380ApplicationMultiple Object ReuseROcontentioncontention5214055016213enq: ID - contention1893977003OtherNIDIDcontentioncontention8222148426979enq: OQ - xsoqhiClose1893977003OtherOLAPI HistoriesOQxsoqhiClosexsoqhiClose8203682185722enq: OQ - xsoqhiFlush1893977003OtherOLAPI HistoriesOQxsoqhiFlushxsoqhiFlush8234194119705enq: OQ - xsoqhistrecb1893977003OtherOLAPI HistoriesOQxsoqhistrecbxsoqhistrecb819523388040enq: OQ - xsoqhiAlloc1893977003OtherOLAPI HistoriesOQxsoqhiAllocxsoqhiAlloc821681553729enq: OQ - xsoq*histrecb1893977003OtherOLAPI HistoriesOQxsoq*histrecbxsoq*histrecb6181911278064enq: OC - contention1893977003OtherOutline CacheOCcontentioncontention6193443769614enq: OL - contention1893977003OtherOutline NameOLcontentioncontention6942071012023enq: PS - contention1893977003OtherPX Process ReservationPScontentioncontention3164129138703enq: PE - contention1893977003OtherParameterPEcontentioncontention6302211137592enq: PF - contention1893977003OtherPassword FilePFcontentioncontention3113733307663enq: PR - contention1893977003OtherProcess StartupPRcontentioncontention353245034220enq: PD - contention1893977003OtherProperty LockPDcontentioncontention615893937616enq: HP - contention1893977003OtherQueue PageHPcontentioncontention7311371132976enq: TQ - TM contention1893977003OtherQueue table enqueueTQTM contentionTM contention733451597502enq: TQ - INI contention1893977003OtherQueue table enqueueTQINI contentionINI contention732717240345enq: TQ - DDL contention1893977003OtherQueue table enqueueTQDDL contentionDDL contention529707813539enq: XR - quiesce database1893977003OtherQuiesce / Force LoggingXRquiesce databasequiesce database5303609173507enq: XR - database force logging1893977003OtherQuiesce / Force LoggingXRdatabase force loggingdatabase force logging553115643876enq: RS - read alert level1893977003OtherReclaimable SpaceRSread alert levelread alert level5482897929244enq: RS - file delete1893977003OtherReclaimable SpaceRSfile deletefile delete549313351369enq: RS - record reuse1893977003OtherReclaimable SpaceRSrecord reuserecord reuse5503504071695enq: RS - prevent file delete1893977003OtherReclaimable SpaceRSprevent file deleteprevent file delete5513170569251enq: RS - prevent aging list update1893977003OtherReclaimable SpaceRSprevent aging list updateprevent aging list update5523178040924enq: RS - persist alert level1893977003OtherReclaimable SpaceRSpersist alert levelpersist alert level5543488540422enq: RS - write alert level1893977003OtherReclaimable SpaceRSwrite alert levelwrite alert level5061281359820enq: RN - contention1893977003OtherRedo Log Nab ComputationRNcontentioncontention5141143317824enq: RT - contention1893977003OtherRedo ThreadRTcontentioncontention6932143046196enq: PI - contention1893977003OtherRemote PX Process Spawn StatusPIcontentioncontention512647852263enq: RP - contention1893977003OtherResilver / RepairRPcontentioncontention3553530171172enq: RU - contention1893977003OtherRolling UpgradeRUcontentioncontention3562020359573enq: RU - waiting1893977003OtherRolling UpgradeRUwaitingwaiting8933315745697enq: TB - SQL Tuning Base Cache Update1893977003OtherSQL Tuning Base Existence CacheTBSQL Tuning Base Cache UpdateSQL Tuning Base Cache Update8942878002362enq: TB - SQL Tuning Base Cache Load1893977003OtherSQL Tuning Base Existence CacheTBSQL Tuning Base Cache LoadSQL Tuning Base Cache Load5943652428359enq: SU - contention1893977003OtherSaveUndo SegmentSUcontentioncontention3031504129838enq: KM - contention1893977003OtherSchedulerKMcontentioncontention3041301289702enq: KT - contention1893977003OtherScheduler PlanKTcontentioncontention1821645217925enq: HW - contention3290255840ConfigurationSegment High Water MarkHWcontentioncontention2002322460838enq: SQ - contention3290255840ConfigurationSequence CacheSQcontentioncontention3521045545254enq: AS - modify service1893977003OtherService OperationsASmodify servicemodify service3512558928434enq: AS - service activation1893977003OtherService OperationsASservice activationservice activation7283429311972enq: SE - contention1893977003OtherSession MigrationSEcontentioncontention5822678203686enq: SK - contention1893977003OtherShrink SegmentSKcontentioncontention1833890744969enq: SS - contention3290255840ConfigurationSort SegmentSScontentioncontention1811649608974enq: ST - contention3290255840ConfigurationSpace TransactionSTcontentioncontention337351221043enq: SP - contention 21893977003OtherSpare EnqueueSPcontention 2contention 2338839059449enq: SP - contention 31893977003OtherSpare EnqueueSPcontention 3contention 33362215147320enq: SP - contention1893977003OtherSpare EnqueueSPcontentioncontention3391340803846enq: SP - contention 41893977003OtherSpare EnqueueSPcontention 4contention 47183398735787enq: SI - contention1893977003OtherStreams Table InstantiationSIcontentioncontention437608373385enq: SW - contention1893977003OtherSuspend WritesSWcontentioncontention7153056899600enq: SR - contention1893977003OtherSynchronized ReplicationSRcontentioncontention5954205956891enq: TT - contention1893977003OtherTablespaceTTcontentioncontention4391231322525enq: TC - contention1893977003OtherTablespace CheckpointTCcontentioncontention440718572278enq: TC - contention21893977003OtherTablespace CheckpointTCcontention2contention27023701540314enq: TO - contention1893977003OtherTemp ObjectTOcontentioncontention571896842959enq: TF - contention1893977003OtherTemporary FileTFcontentioncontention5802667616873enq: TS - contention1893977003OtherTemporary SegmentTScontentioncontention9013243557671enq: TH - metric threshold evaluation1893977003OtherThreshold ChainTHmetric threshold evaluationmetric threshold evaluation5921629782133enq: TX - contention1893977003OtherTransactionTXcontentioncontention188310662678enq: TX - row lock contention4217450380ApplicationTransactionTXrow lock contentionrow lock contention189281768874enq: TX - allocate ITL entry3290255840ConfigurationTransactionTXallocate ITL entryallocate ITL entry1901035026728enq: TX - index contention3875070507ConcurrencyTransactionTXindex contentionindex contention523622794581enq: PL - contention1893977003OtherTransportable TablespacePLcontentioncontention5932458904239enq: US - contention1893977003OtherUndo SegmentUScontentioncontention272738183602enq: UL - contention4217450380ApplicationUser-definedULcontentioncontention9022152050500enq: RR - contention1893977003OtherWorkload Capture and ReplayRRcontentioncontention