Oracle Database Concurrancy Issue: Database Sessions Getting Blocked In OAAM (Doc ID 1444132.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Adaptive Access Manager - Version 10.1.4.5.0 to 10.1.4.5.0 [Release 10g]
Information in this document applies to any platform.

Symptoms

one of the session in the database which was doing an Insert causes the other sessions to be blocked and as a result the entire database gets blocked.

The Insert statement is as below

INSERT INTO VCRYPT_TRACKER_USERNODE_LOGS (USER_NODE_LOG_ID, AUTH_CLIENT_TYPE_CODE, CLIENT_VERSION, REQUEST_ID, DIGITAL_CLIENT_TYPE_CODE, CLIENT_DEVICE_ID, DIGITAL_CLIENT_VERSION, NODE_ID, SECURE_CLIENT_TYPE_CODE, TRACKER_NODE_HISTORY_ID, SECURE_CLIENT_VERSION, USER_LOGIN_ID, DIGITAL_FP_ID, USER_SUB_GROUP_ID, FPRINT_ID, CREATE_TIME, LOAD_DURATION, EXEC_TIME, DEVICE_SCORE, SENT_DIG_SIG_COOKIE, PREAUTH_SCORE, SENT_SECURE_COOKIE, POST_SCORE, PREAUTH_ACTION, CACHE, POST_ACTION, USER_GROUP_ID, CITY_SCORE, UPDATE_TIME, STATE_SCORE, EXPECTED_DIG_SIG_COOKIE, COUNTRY_SCORE, EXT_SESSION_ID, POST_PROCESS_STATUS, AUTH_STATUS, POST_PROCESS_RESULT, EXPECTED_SECURE_COOKIE, LOGIN_FLAG, IS_REGISTERED, IS_DEVICE_DERIVED, USER_ID, NOTES, BASE_IP_ADDR, REMOTE_IP_ADDR) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44)

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