DAC 11g: CONNECTION_ISSUE <schema> Acquiring Semaphore Took X Mins YY Secs ZZZ Millis

(Doc ID 2063064.1)

Last updated on AUGUST 09, 2016

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?


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms