Oracle 19c的Failed Logon Delay竟然排在top 2
处理办法:禁用登录延迟alter system set "_sys_logon_delay"=0 scope=spfile sid='*';需申请停机时间,重启库生效。相关参考:https://blog.csdn.net/m0_37625564/article/details/128798375
·


处理办法:禁用登录延迟
alter system set "_sys_logon_delay"=0 scope=spfile sid='*';
需申请停机时间,重启库生效。
SQL> show parameter logon;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> select a.ksppinm name,b.ksppstvl value,a.ksppdesc description
from x$ksppi a,x$ksppcv b
where a.indx = b.indx
and a.ksppinm like '_sys_logon_delay';
NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
_sys_logon_delay
1
The failed logon delay for the database instance
SQL> alter system set "_sys_logon_delay"=0 scope=both sid='*';
alter system set "_sys_logon_delay"=0 scope=both sid='*'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set "_sys_logon_delay"=0 scope=spfile sid='*';
System altered.
SQL>
相关参考:
更多推荐
所有评论(0)