Entries by Arsalan

Oracle Bug 28789533

Query v$sql_monitor is slow. the execution plan shows ‘Full Table Scan’ on Fixed table ‘X$KESWXMON’. The fix for 28789533 is first included in: Oracle 19.11.0.0 APR 2021 DB RU

The behavior change of the max entries of Password File Management since Oracle Database 12.2.

Since Oracle Database 12.2, due to designing change, it becomes no limitation of max entries of the password file, and the “entries” argument of ‘orapwd’ command is deprecated, and password file is made auto-extensible, and prior to 12.2.0.1, password file is made auto-extensible ORA-01996 will happen when the number entries in Password file exceeds the “entries” […]