队列阻塞及描述

最新推荐文章于 2024-03-29 09:45:10 发布

道行尚浅

最新推荐文章于 2024-03-29 09:45:10 发布

阅读量2.3k

点赞数

分类专栏： ORACLE优化文章标签：队列

本文链接：https://blog.csdn.net/daohengshangqian/article/details/46848925

版权

本文深入探讨了队列阻塞的概念，分析了在处理并发和多线程操作中队列阻塞的原因及其影响，同时提供了避免和解决队列阻塞的策略，帮助读者更好地理解和优化系统性能。

摘要由CSDN通过智能技术生成

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	REQ_REASON
862	3282679649	enq: FG - LGWR redo generation enq race	1893977003	Other	ACD Relocation Gate Enqueue	FG	LGWR redo generation enq race	LGWR redo generation enq race
861	903153076	enq: FG - FG redo generation enq race	1893977003	Other	ACD Relocation Gate Enqueue	FG	FG redo generation enq race	FG redo generation enq race
860	1457820412	enq: FG - serialize ACD relocate	1893977003	Other	ACD Relocation Gate Enqueue	FG	serialize ACD relocate	serialize ACD relocate
735	798324601	enq: MH - contention	1893977003	Other	AQ Notification Mail Host	MH	contention	contention
736	4174613831	enq: ML - contention	1893977003	Other	AQ Notification Mail Port	ML	contention	contention
739	3111555168	enq: XH - contention	1893977003	Other	AQ Notification No-Proxy	XH	contention	contention
737	148033462	enq: PH - contention	1893977003	Other	AQ Notification Proxy	PH	contention	contention
738	3322341088	enq: SF - contention	1893977003	Other	AQ Notification Sender	SF	contention	contention
740	3791087697	enq: WA - contention	1893977003	Other	AQ Notification Watermark	WA	contention	contention
841	2345563243	enq: AD - allocate AU	1893977003	Other	ASM Disk AU Lock	AD	allocate AU	allocate AU
842	143335296	enq: AD - deallocate AU	1893977003	Other	ASM Disk AU Lock	AD	deallocate AU	deallocate AU
845	685231043	enq: DG - contention	1893977003	Other	ASM Disk Group Modification	DG	contention	contention
847	4039922119	enq: HD - contention	1893977003	Other	ASM Disk Header	HD	contention	contention
825	4003623979	enq: AM - shutdown	1893977003	Other	ASM Enqueue	AM	shutdown	shutdown
824	409056071	enq: AM - client registration	1893977003	Other	ASM Enqueue	AM	client registration	client registration
826	3718305	enq: AM - rollback COD reservation	1893977003	Other	ASM Enqueue	AM	rollback COD reservation	rollback COD reservation
827	827631834	enq: AM - ASM File Destroy	1893977003	Other	ASM Enqueue	AM	ASM File Destroy	ASM File Destroy
840	1688174401	enq: XQ - relocation	1893977003	Other	ASM Extent Relocation Enqueue	XQ	relocation	relocation
839	3051305468	enq: XQ - recovery	1893977003	Other	ASM Extent Relocation Enqueue	XQ	recovery	recovery
855	3182712926	enq: FA - access file	1893977003	Other	ASM File Access Lock	FA	access file	access file
837	4186342174	enq: CM - gate	1893977003	Other	ASM Instance Enqueue	CM	gate	gate
838	3394651275	enq: CM - instance	1893977003	Other	ASM Instance Enqueue	CM	instance	instance
846	3688395675	enq: DD - contention	1893977003	Other	ASM Local Disk Group	DD	contention	contention
870	1698021162	enq: PT - contention	1893977003	Other	ASM Partnership and Status Table	PT	contention	contention
869	11871430	enq: RB - contention	1893977003	Other	ASM Rollback Recovery	RB	contention	contention
887	1641438405	enq: WF - contention	1893977003	Other	AWR Flush	WF	contention	contention
888	2389341073	enq: WP - contention	1893977003	Other	AWR Purge	WP	contention	contention
895	3691188946	enq: SH - contention	1893977003	Other	Active Session History Flushing	SH	contention	contention
896	955173113	enq: AF - task serialization	1893977003	Other	Advisor Framework	AF	task serialization	task serialization
723	545059663	enq: AT - contention	1893977003	Other	Alter Tablespace	AT	contention	contention
815	541043045	enq: AW - user access for AW	1893977003	Other	Analytic Workspace	AW	user access for AW	user access for AW
816	2247828282	enq: AW - AW generation lock	1893977003	Other	Analytic Workspace	AW	AW generation lock	AW generation lock
813	3728184289	enq: AW - AW$ table lock	1893977003	Other	Analytic Workspace	AW	AW$ table lock	AW$ table lock
814	2438512004	enq: AW - AW state lock	1893977003	Other	Analytic Workspace	AW	AW state lock	AW state lock
817	2009316128	enq: AG - contention	1893977003	Other	Analytic Workspace Generation	AG	contention	contention
638	1444835457	enq: ZA - add std audit table partition	1893977003	Other	Audit Partition	ZA	add std audit table partition	add std audit table partition
637	1704200513	enq: AU - audit index file	1893977003	Other	Audit index file	AU	audit index file	audit index file
704	2212717019	enq: BF - allocation contention	1893977003	Other	BLOOM FILTER	BF	allocation contention	allocation contention
705	2476632936	enq: BF - PMON Join Filter cleanup	1893977003	Other	BLOOM FILTER	BF	PMON Join Filter cleanup	PMON Join Filter cleanup
520	1796838767	enq: BR - proxy-copy	1893977003	Other	Backup/Restore	BR	proxy-copy	proxy-copy
519	3954034543	enq: BR - file shrink	1893977003	Other	Backup/Restore	BR	file shrink	file shrink
505	1555037586	enq: WL - conten