获取当前scn号scn1_如何查询当前数据库的SCN值

最初由 orientzkd 发布

[B][php]

1.在Oracle9i及以上版本中

可以使用dbms_flashback.get_system_change_number来获得

SQL> select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER------------------------                 2982184

2.在Oracle9i之前

可以通过查询x$ktuxe获得最接近当前系统scn值

X$KTUXE-------------[K]ernel [T]ransaction [U]ndo Transa[x]tion [E]ntry (table)

SQL> select max(ktuxescnw*power(2,32)+ktuxescnb) from x$ktuxe;

MAX(KTUXESCNW*POWER(2,32)+KTUXESCNB)------------------------------------                             2980613

3.通过oradebug获取

以前在l2g32003的站点上看到使用oradebug获取SCN的方法,转引在这里:

[oracle@neirong oracle]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Dec 21 21:04:24 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.4.0 - Production

SQL> col a for 999999999999SQL> oradebug setmypidStatement processed.SQL> oradebug DUMPvar SGA kcsgscn_kcslf kcsgscn_ [1200BC68, 1200BC88) = 00000003 BA84F392 00071266 00000000 00000000 00000000 00000000 1200B948SQL> select to_number('3BA84F392','xxxxxxxxxxxx') a from dual;

A-------------  16014177170

SQL> select dbms_flashback.get_system_change_number a from dual;

A-------------  16014177255

SQL>

[/php] [/B]