9.2 V$SECUREFILE_TIMER

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