Oracle 视图 V$SECUREFILE_TIMER 官方解释,作用,如何使用详细说明

本站中文解释

V$SECUREFILE_TIMER视图用于查看Oracle服务器的安全文件计时器的状态。它显示了服务器上每个安全文件之间的时间差异,包括服务器上存在的安全文件的总数以及每个安全文件正确完成在哪一次时间节点发生事件。客户可以使用V$SECUREFILE_TIMER视图检查服务器上每个安全文件之间的时间差异,以确定服务器上安全文件的准确性和可靠性。它显示的信息可帮助系统管理员了解并检查服务器上每个安全文件的状态,检查系统的安全性和权限,并检查安全文件的完整性。

要使用V$SECUREFILE_TIMER视图,只需打开Oracle数据库控制台,输入:select * from v$securefile_timer;

将显示服务器上所有安全文件的状态。查看每个安全文件的完成时间,只需要select 文件名/filename, completion_time from v$securefile_timer;

此外,可以使用where子句来查找特定安全文件的信息,例如select * from v$securefile_timer where file_name=’filename.txt’;

官方英文解释

V$SECUREFILE_TIMER displays information about time taken (in microseconds) by functions of SecureFiles. These timer values are collected per session.
Column Datatype Description

NAME

VARCHAR2(50)

Name of the function

LAYER_ID

NUMBER

ID of the layer that the function belongs to:

  • 0 – Entire Subtree

  • 1 – Delta Updates

  • 2 – Write gather cache

  • 3 – Deduplication

  • 4 – Compression & Encryption

  • 5 – Inode

  • 6 – Space

  • 7 – Utilities

  • 8 – Row-Column Intersection

OWNTIME

NUMBER

Total time taken by the function

MAXTIME

NUMBER

Maximum time taken by a single call

MINTIME

NUMBER

Minimum time taken by a single call

INVOCATIONS

NUMBER

Number of times the function was invoked

LAYER_NAME

VARCHAR2(50)

Name of the layer to which the function belongs

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$SECUREFILE_TIMER 官方解释,作用,如何使用详细说明