Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$ENCRYPTED_TABLESPACES

V$ENCRYPTED_TABLESPACES displays information about the tablespaces that are encrypted.

Column Datatype Description
TS# NUMBER Tablespace number
ENCRYPTIONALG VARCHAR2(7) Encryption algorithm:
  • NONE

  • 3DES168

  • AES128

  • AES192

  • AES256

ENCRYPTEDTS VARCHAR2(3) Indicates whether the tablespace is encrypted (YES) or not (NO)
ENCRYTPEDKEYFoot 1  RAW(32) Encrypted version of the tablespace key for the encrypted tablespace
MASTERKEYIDFootref 1 RAW(16) ID of the master key that was used to encrypt the tablespace key
BLOCKS_ENCRYPTEDFootref 1 NUMBER Number of tablespace blocks that have been encrypted during the lifetime of this instance
BLOCKS_DECRYPTEDFootref 1 NUMBER Number of tablespace blocks that have been decrypted during the lifetime of this instance

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).