Database Reference
In-Depth Information
needs to be taken when engaging with any kind of manual interactions with the
database. It is with experience that an administrator will gain insight on the differ-
ent tables and ways to perform common administration tasks like purging, parti-
tioning, and reclaiming disk space. Improper purging or ignorantly using a wrong
mix of configuration parameters will eventually lead to orphaned instances that
will make managing the database difficult. A good starting point is to use the
out-of-the-box packages that are provided by Oracle to take care of the purging
and partitioning activities. It is essential to have an overall understanding of key
tables that make up a majority of the Dehydration Store.
A few of them are described in the following table ,along with the nature of the
instance related data they store.
Table
Description
ATTACHMENT
Attachments of a process instance are persisted as
variables in this table.
ATTACHMENT_REF
An attachment can be referenced by multiple process
instances. The references to an attachment are saved
in the ATTACHMENT_REF table.
AUDIT_DETAILS
Activities inside a process such as an assign activity
log variables as audit details by default in this table.
This behavior is controlled through the
auditLevel
configuration property in place. The
auditDe-
tailThreshold
configuration property is used by
this table. If the size of a detail is larger than the value
specified for this property, it is placed in this table.
Otherwise, it is placed in the AUDIT_TRAIL table.
