Changing Password for Common User Hangs with Database Vault Enabled
(Doc ID 2746980.1)
Last updated on JUNE 29, 2021
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Database 19c Multitenant with Database Vault: Changing password for common user hangs, waiting on Concurrency row cache lock. This issue may occur when changing passwords for Database Vault Owner or Account Manager, but it is also occurring for C## common users. And it only happens with Database Vault enabled, if DV is disabled the user can change its password.
Trace file shows ALTER USER statement followed by a lot of recursive sql and it eventually starts to hang on:
/* SQL Analyze(860,0) */ SELECT /*+PARALLEL(1) NO_STATEMENT_QUEUING */ * FROM X$KXFTASK /*kpdbReplayDDL,PDB_Replay_DDL*/
AWR report shows "row cache lock" wait event
Change password for common user
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