My Oracle Support Banner

DELETE From Sys.snap_logdep$ Consuming 100% CPU (Doc ID 2754233.1)

Last updated on FEBRUARY 20, 2021

Applies to:

Oracle Database - Standard Edition - Version 19.9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

An on-commit mview is using high cpu utilization.

Below query causing 100% CPU

DELETE from sys.snap_logdep$ where snapid=:1 and tableobj# in ( select tableobj# from sys.snap$ s, sys.snap_logdep$ l where s.snapid=:1 and s.snapid=l.snapid and tableobj# NOT IN ( select OBJECT_ID from dba_objects o , dba_dependencies d where o.OWNER=d.REFERENCED_OWNER and o.OBJECT_NAME=d.REFERENCED_NAME and d.TYPE='MATERIALIZED VIEW' and d.owner = s.sowner and d.name = s.vname))

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.