Thread: scn
-
scn
Hi,
Just a strange change.
No activity is going on (ofcourse oracle internal activities keep scn moving)
The first query gives me same scn (always) but the reverse always gives one incremented......
Any particular reason ??
thx
SQL> Select CURRENT_SCN from v$database
2 union all
3 Select dbms_flashback.get_system_change_number AS CURRENT_SCN from dual;
CURRENT_SCN
-----------
514882
514882
SQL> Select dbms_flashback.get_system_change_number AS CURRENT_SCN from dual
2 union all
3 Select CURRENT_SCN from v$database;
CURRENT_SCN
-----------
514890
514891
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|