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 126.96.36.199 and later
Information in this document applies to any platform.
BI Apps 188.8.131.52 version, in DAC 184.108.40.206.4
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