E.1 Overview

Database tables in the Oracle Adaptive Access Manager database are divided into the following categories:

Static partition tables
Transactional partition tables
Non-partitioned tables

Note:

All the tables contain the composite partition (RANGE, HASH). The Range partition is created using CREATE_TIME while the HASH key is defined based on application logic.

lists the Oracle Adaptive Access Manager (OAAM) partition tables. All the other tables are non-partitioned.

Table E-1 OAAM Database Partition Tables

Table Type	Frequency	Table Name
Static Partition	Monthly	V_USER_QA V_USER_QA_HIST
Transactional Partition	Monthly	VCRYPT_TRACKER_NODE_HISTORY VCRYPT_TRACKER_USERNODE_LOGS VCRYPT_TRACKER_NODE VT_USER_DEVICE_MAP V_MONITOR_DATA VT_SESSION_ACTION_MAP VT_ENTITY_ONE VT_ENTITY_ONE_PROFILE VT_USER_ENTITY1_MAP VT_ENT_TRX_MAP VT_TRX_DATA VT_TRX_LOGS
Transactional Partition	Weekly	VR_POLICYSET_LOGS VR_POLICY_LOGS VR_RULE_LOGS VR_MODULE_LOGS

Table Type

Frequency

Table Name

Static Partition

Monthly

V_USER_QA

V_USER_QA_HIST

Transactional Partition

Monthly

VCRYPT_TRACKER_NODE_HISTORY

VCRYPT_TRACKER_USERNODE_LOGS

VCRYPT_TRACKER_NODE

VT_USER_DEVICE_MAP

V_MONITOR_DATA

VT_SESSION_ACTION_MAP

VT_ENTITY_ONE

VT_ENTITY_ONE_PROFILE

VT_USER_ENTITY1_MAP

VT_ENT_TRX_MAP

VT_TRX_DATA

VT_TRX_LOGS

Transactional Partition

Weekly

VR_POLICYSET_LOGS

VR_POLICY_LOGS

VR_RULE_LOGS

VR_MODULE_LOGS