Re: Does oracle capture ROWID of rows returned for SELECT statements being run on a table?

Posted by ErmanArslansOracleBlog on Mar 22, 2018; 4:44pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Does-oracle-capture-ROWID-of-rows-returned-for-SELECT-statements-being-run-on-a-table-tp5463p5466.html

You can create triggers for this.. (but this has performance overhead)

You can also use Flashback Data Archive for this.. (recommended)
If your DB version is 12C, then you are lucky..

Flashback Data Archive has been extended to enable the capture of context-level information automatically and without changes to the base tables.
When rows are inserted, updated, or deleted in the tables which are associated with a flashback archive, any context information in the standard USERENV context (as well as any custom user-defined contexts) will be captured for each transaction..

Reference:

A Fresh Look at Auditing Row Changes By Connor McDonald

http://www.oracle.com/technetwork/issue-archive/2016/16-mar/o26performance-2925662.html