Oracle 视图 DBA_EXTERNAL_SCN_ACTIVITY 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_EXTERNAL_SCN_ACTIVITY是提供可以查看用户的外部连接SCN(System Change Number)信息的数据字典，可以显示用户正在使用的SCN及书记在特定时间点上的SCN。

使用DBA_EXTERNAL_SCN_ACTIVITY：

1. 首先查询当前可用SCN：
SELECT APPLIED_SCN FROM DBA_EXTERNAL_SCN_ACTIVITY;

2. 查看特定时间段内的SCN：
SELECT APPLIED_SCN FROM DBA_EXTERNAL_SCN_ACTIVITY
WHERE START_TIME to_date( 201410101201 , YYYYMMDDHH24MISS );

3. 查询特定用户的SCN：
SELECT APPLIED_SCN FROM DBA_EXTERNAL_SCN_ACTIVITY
WHERE USERNAME= USER TEST

4. 查看特定用户特定时间段内的SCN：
SELECT APPLIED_SCN FROM DBA_EXTERNAL_SCN_ACTIVITY
WHERE USERNAME= USER TEST
AND START_TIME to_date( 201410101201 , YYYYMMDDHH24MISS );

官方英文解释

DBA_EXTERNAL_SCN_ACTIVITY works in conjunction with the DBA_DB_LINK_SOURCES and DBA_DB_LINKS views to determine the source of high SCN activities.

If the SCN is increased by an inbound database link, then you can join the DBA_EXTERNAL_SCN_ACTIVITY view with the DBA_DB_LINK_SOURCES view on the INBOUND_DB_LINK_SOURCE_ID column to get details of the remote database where the SCN increase originated.

If the SCN is increased by an outbound database link, then the INBOUND_DB_LINK_SOURCE_ID column will be NULL, but the OUTBOUND_DB_LINK_NAME and OUTBOUND_DB_LINK_OWNER columns can be joined with the DB_LINK and OWNER columns respectively in the DBA_DB_LINKS view to determine the remote database that caused the SCN increase.

If neither of the above cases are true (the INBOUND_DB_LINK_SOURCE_ID, OUTBOUND_DB_LINK_NAME, and OUTBOUND_DB_LINK_OWNER are all NULL), then the SCN increase resulted from a client connection and not as a result of a database link to or from another database. You can join the SESSION_ID and SESSION_SERIAL# columns with the SID and SERIAL# columns in V$SESSION to get the client session details.

In a multitenant container database (CDB) environment, for every DBA_ view, there is a corresponding CDB_ view that contains data for all the pluggable databases (PDBs) in the CDB.

As the SCN is a property of the CDB (and not a PDB), a DBA interested in understanding large SCN jumps will likely find the CDB_EXTERNAL_SCN_ACTIVITY view more useful for diagnosing SCN jumps on a CDB. Querying the CDB_EXTERNAL_SCN_ACTIVITY view from CDB$ROOT ensures that external SCN jumps occurring on all PDBs are looked at and noticed. On the other hand, a query on the corresponding DBA_EXTERNAL_SCN_ACTIVITY view, or a query on the CDB_EXTERNAL_SCN_ACTIVITY view done from a PDB would only show data for that PDB (that is, details regarding any external activity that occurred on that specific PDB that resulted in large SCN jumps).

Note that the CDB_ views would only show data from PDBs that are open at the time the query is issued. Therefore, when you are diagnosing sources of external SCN activities, Oracle recommends that you keep open any or all PDBs that might contain useful information for the diagnosis.

Session identifier of the local session that created this entry. Maps to V$SESSION.SID and to V$ACTIVE_SESSION_HISTORY.SESSION_ID.

Session serial number of the local session that created this entry. Maps to V$SESSION.SERIAL# and to V$ACTIVE_SESSION_HISTORY.SESSION_SERIAL#.

Session identifier that can be joined with DBA_AUDIT_TRAIL.SESSIONID or UNIFIED_AUDIT_TRAIL.SESSIONID (depending on which kind of auditing is enabled). Null if auditing is not enabled.

Oracle username of the user who logged into the local database. Maps to V$SESSION.USERNAME.

If the SCN was bumped by an inbound database link, then this is the inbound database link identified by the DBA_DB_LINK_SOURCES.SOURCE_ID database link.

If the SCN was not increased by an inbound database link, then this value is null.

If the SCN was bumped by an outbound database link, then this is the outbound database link identified by the DBA_DB_LINKS.DB_LINK database link.

Using this column and the OUTBOUND_DB_LINK_OWNER column, you can determine the source of the SCN increase for outbound links.

If the SCN was not increased by an outbound database link, then this value is null.

If the SCN was bumped by an outbound database link, then this is the owner of the outbound database link identified by DBA_DB_LINKS.OWNER.

Using this column and the OUTBOUND_DB_LINK_NAME column, you can determine the source of the SCN increase for outbound links.

If the SCN was not increased by an outbound database link, then this value is null.

Regular SCN activities which do not result in errors or warnings are not captured . SCN errors and warnings also appear in alert.log.

The external SCN received from an inbound database link, an outbound database link, or a client

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 DBA_EXTERNAL_SCN_ACTIVITY 官方解释，作用，如何使用详细说明