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 |