首页 » ORACLE, ORACLE [C]系列 » 对于登录相关的 LAST SUCCESSFUL LOGIN TIME的Library cache lock又出新参数

对于登录相关的 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

打赏

目前这篇文章还没有评论(Rss)

我要评论