Taking advantage of Oracle Database features
Flashback Data archive and undo retention
If the --includeScn option of the
anchor command is used, or when using the
monitor command, Provendb for Oracle issues Flashback queries to collect point in time data for a row. If a table is being managed by a Flashback Data Archive, then these proofs can be compared to the database up to the flashback data archive retention period. If no flashback data archive is implemented, then the proofs cannot be compared to the database after the
undo_retention configuration parameter has been exceeded.
Proofs that are generated against historical data can still be used to prove historical data providing that the --validate and --includeRowIds option of the anchor command is specified. This generates an output file that contains both the data and the proofs for all the historical row data. This can be validated directly without needing access to historical database records.
Configuring a DBMS Alert
monitor mode, ProvenDB for Oracle will wakup to check for changes on a schedule. However, if the
dbmsAlert configuration option is set, then ProvenDB for Oracle will wake up if a
provendb_alert alert is issued. You could attach a trigger to a table of interest to ensure that the ProvenDB for Oracle agent will wake up whenever a transaction affects that table. For instance:
CREATE OR REPLACE TRIGGER contractsTable_proofable_trg AFTER INSERT OR UPDATE OR DELETE ON contractsTable BEGIN DBMS_ALERT.SIGNAL('provendb_alert','proofable table modified'); END;
Updated over 2 years ago