对于登录相关的 LAST SUCCESSFUL LOGIN TIME的Library cache lock又出新参数
之前分享过2篇关于 LAST SUCCESSFUL LOGIN TIME 的笔记，Oracle19c 建议的 One-off patch之disable LAST SUCCESSFUL LOGIN TIME 和Oracle 12c New Feature: Last Login Time for Non-Sys Users， 最近这个特性Oracle又给出来了2个参数，还是很巧妙，继续记录一下。
上周发布了新 Bug 33121934 Library cache lock / load lock / mutex x during connection storm， 也是在登录高并发时，因为更新最后登录时间特性出现的library cache lock等问题，之前是引入_disable_last_successful_login_time禁用，这次引入了2个新的隐藏参数可以细化行为的更新， 不用再那么频繁。
_disable_last_successful_login_time_unlimited_iat
– This controls whether users associated with a password profile with UNLIMITED Inactive Account Time will not have their LSLT updated.
_granularity_last_successful_login_time
– This controls the granularity of LSLT update for _ALL_ users. Say, it is set to 30 seconds and then all users logons within that period of 30 seconds will NOT update the LSLT
微信扫一扫，打赏作者吧～
对不起，这篇文章暂时关闭评论。