重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: 11.2.0.4及以上脚本检查数据库SCN还有多少天限制的脚本？ [打印本页]

作者: 郑全 时间: 2025-8-14 16:28
标题: 11.2.0.4及以上脚本检查数据库SCN还有多少天限制的脚本？

set serveroutput on;
declare
v_rsl number;
v_headroom_in_scn number;
v_headroom_in_sec number;
v_cur_scn_compat number;
v_max_scn_compat number;
begin
dbms_scn.getcurrentscnparams(v_rsl, v_headroom_in_scn, v_headroom_in_sec, v_cur_scn_compat, v_max_scn_compat);
dbms_output.put_line('reasonable scn limit (soft limit)    : ' || to_char(v_rsl,'999,999,999,999,999,999'));
dbms_output.put_line('headroom in scn                            : ' || to_char(v_headroom_in_scn,'999,999,999,999,999,999'));
dbms_output.put_line('headroom in seconds                   : ' || v_headroom_in_sec);
dbms_output.put_line('headroom in days                         : ' || round(v_headroom_in_sec/3600/24));
dbms_output.put_line('current scn compatibility scheme  : ' || v_cur_scn_compat);
dbms_output.put_line('max scn compatibility scheme    : ' || v_max_scn_compat);
end;

比如我的机器

SQL> select BANNER_FULL from v$version;

BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.26.0.0.0

SQL>  select CURRENT_SCN from v$database;

CURRENT_SCN
-----------
2775572

SQL> set serveroutput on;
SQL> declare
  2 v_rsl number;
  3 v_headroom_in_scn number;
  4 v_headroom_in_sec number;
  5 v_cur_scn_compat number;
  6 v_max_scn_compat number;
  7  begin
  8 dbms_scn.getcurrentscnparams(v_rsl, v_headroom_in_scn, v_headroom_in_sec, v_cur_scn_compat, v_max_scn_compat);
  9 dbms_output.put_line('reasonable scn limit (soft limit)    : ' || to_char(v_rsl,'999,999,999,999,999,999'));
10 dbms_output.put_line('headroom in scn                            : ' || to_char(v_headroom_in_scn,'999,999,999,999,999,999'));
11 dbms_output.put_line('headroom in seconds                   : ' || v_headroom_in_sec);
12 dbms_output.put_line('headroom in days                         : ' || round(v_headroom_in_sec/3600/24));
13 dbms_output.put_line('current scn compatibility scheme  : ' || v_cur_scn_compat);
14 dbms_output.put_line('max scn compatibility scheme    : ' || v_max_scn_compat);
15  end;
16  /
reasonable scn limit (soft limit)    :    54,894,289,911,808
headroom in scn                            :    54,894,287,136,233
headroom in seconds                   : 558413565
headroom in days                         : 6463
current scn compatibility scheme  : 3
max scn compatibility scheme    : 3

PL/SQL procedure successfully completed.

SQL>

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)