While Running The Full Load Locks Are Getting Applied . (Doc ID 2093019.1)

Last updated on JUNE 26, 2016

Applies to:

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

Symptoms

Problem Description
---------------------------------------------------
when we are running full for BI apps 11.1.1.8.1 HR

  We are watching the load from Database perspesctive and we are noticing a significant number of sessions being held cause of locks caused by application (ODI Mappings).

  Select DBMS_LOCK.REQUEST (:1, :2) from dual; is the SQL being submitted.

  Attaching reports so you can view by your own. Please advise if there is anything to be changed / improved on the Mappings. There might be some Support recommendation on that.


because of which falling incidents are raised .
  See below the manifestation of the issues reported on previous email.
  These are Monitoring SRs opened when the issues happened. This is something we must work on, as they are related to application SQL issue caused by locking mechanisms.

Customer Name Group/Instance
Event Type
TICKET Target Type
Metric Name
Assigned To Created on
Status (In EM*)
Hostname
Gc Name
Advantage Sales And Marketing PADV23 Application Issue 3-11396649315
Database Instance Blocking_Session OHSMON-L1 17-SEP-2015 OPEN for 31 Min vmsodadvg009 odem3
Advantage Sales And Marketing PADV23 Application Issue 3-11396653092
Database Instance Max_Session OHSMON 17-SEP-2015 CLOSED in 15 Min vmsodadvg009 odem3
Advantage Sales And Marketing PADV23 Application Issue 3-11396653092
Database Instance Max_Session OHSMON 17-SEP-2015 OPEN for 8 Min vmsodadvg009 odem3

Cause

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