1 PACKAGE DBMS_SCN AUTHID CURRENT_USER IS
2
3 DBMS_SCN_API_MAJOR_VERSION CONSTANT NUMBER := 1;
4 DBMS_SCN_API_MINOR_VERSION CONSTANT NUMBER := 0;
5
6 PROCEDURE GetCurrentSCNParams(
7 rsl OUT number,
8 headroom_in_scn OUT number,
9 headroom_in_sec OUT number,
10 cur_scn_compat OUT number,
11 max_scn_compat OUT number);
12
13 -- Currently no exceptions are thrown.
14 -- rsl - Reasonable SCN Limit as of 'now'
15 -- headroom_in_scn - Difference between current SCN and RSL
16 -- headroom_in_sec - number of seconds it would take to reach RSL
17 -- assuming a constant SCN consumption rate associated
18 -- with current SCN compatibility level
19 -- cur_scn_compat - current value of SCN compatibility
20 -- max_scn_compat - max value of SCN compatibility this database
21 -- understands
22
23 FUNCTION GetSCNParamsByCompat(
24 compat IN number,
25 rsl OUT number,
26 headroom_in_scn OUT number,
27 headroom_in_sec OUT number
28 ) RETURN boolean;
29
30 -- compat -- SCN compatibility value
31 -- rsl -- Reasonable SCN Limit
32 -- headroom_in_scn -- Difference between current SCN and RSL
33 -- headroom_in_sec -- number of seconds it would take to reach RSL
34 -- assuming a constant SCN consumption rate associated
35 -- with specified database SCN compatibility
36 --
37 -- Returns False if 'compat' parameter value is invalid, and OUT parameters
38 -- are not updated.
39
40 PROCEDURE GetSCNAutoRolloverParams(
41 effective_auto_rollover_ts OUT DATE,
42 target_compat OUT number,
43 is_enabled OUT boolean);
44
45 -- effective_auto_rollover_ts - timestamp at which rollover becomes
46 -- effective
47 -- target_compat - SCN compatibility value this database
48 -- will move to, as a result of
49 -- auto-rollover
50 -- is_enabled - TRUE if auto-rollover feature is
51 -- currently enabled
52
53 PROCEDURE EnableAutoRollover;
54
55 PROCEDURE DisableAutoRollover;
56
57 END DBMS_SCN;