DAC 11g: CONNECTION_ISSUE <schema> Acquiring Semaphore Took X Mins YY Secs ZZZ Millis
Last updated on AUGUST 09, 2016
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11 and later
Information in this document applies to any platform.
BI Apps 18.104.22.168 version, in DAC 22.214.171.124.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?
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