The sessions used by APPLY can access various information pertaining to the data being applied. See also Triggers.
...
- is_dbreplicate_session: set to true in APPLY session.
xid, sid, serial, cuser, luser, cliinfo, osuser, machine, osterm, osproc, osprog, scn, datetime: audit information from the source. Identical to values described in CDC/ Audit for Real-Time Data Warehousing. By default, this is set on transaction start and before execution of PL/SQL conflict handler.
- conflict_sqlerrm: error message of current conflict. Updated before execution of PL/SQL conflict handler.
...
Only flag to identify that the session was spawned by APPLY process is available: @is
| No Format |
|---|
@is_dbreplicate_session is set to 1 |
...
MySQL
Only flag to identify that the session was spawned by APPLY process is available: context
| No Format |
|---|
context_info is set to 1 |
...