My Oracle Support Banner

Deleted Services Are Not Cleaned Up from X$KSWSASTAB, Causing Slowness In Querying GV$ACTIVE_SERVICES (Doc ID 2639579.1)

Last updated on APRIL 17, 2023

Applies to:

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


When running a query which joins gv$active_services view, you may encounter slowness due to excessive cpu load or "latch: active service list" wait event, especially when the view is joined with another table/view using nested loops join. 


In one report, problem was seen with a query (sql_id=bhjxxwujr3ac3) which is executed from Enterprise Manager agent.




This is a dataguard environment, and there has been a switchover from standby to primary database.



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

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