从白皮书:
Flashback Data Archive creates an
internal history table for every
tracked table. The internal history
table is initially a replica of the
FDA-enabled table with additional
Metadata columns. When one or more
columns in the tracked table are
updated,a new row is inserted into
the history table that is the
before-image of the row before the
transaction. UPDATE and DELETE
operations generate a new record in
the history table,but INSERT
operations do not – inserted rows
appear in the base table. The internal
history table is partitioned for
better performance,and compressed to
reduce disk space requirements. No
modifications are allowed to internal
history tables. Applications and users
can use the ‘AS OF’ and ‘VERSIONS
BETWEEN’ sql constructs to seamlessly
query the historical data.
是(开源)替代历史跟踪吗?