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