Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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