My Oracle Support Banner

DAC 11g: CONNECTION_ISSUE <schema> Acquiring Semaphore Took X Mins YY Secs ZZZ Millis (Doc ID 2063064.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


BI Apps version, in DAC

Error: "CONNECTION_ISSUE <Datawarehouse_schema> acquiring semaphore took X mins YY secs ZZZ millis "

An execution plan took 23 Hours to complete. It was found from the DAC EP task details that Create and Drop Indexes are running for a very long time. The DBA Team confirmed that its actually not taking that much time at DB level.
The DAC log has lot of connection issue errors, Example: "CONNECTION_ISSUE BI_TGT_EDWH acquiring semaphore took 6 mins 44 secs 397 millis"

What can be the possible reason for this issue?


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.