Editor Tracking is a mechanism to add one or more attributes to a geodatabase feature class (table) in such a way that all edits are tagged with additional information. The documentation at About tracking an editor's changes to data lists four attributes which can be maintained:
- The name of the user who created it.
- The date and time it was created.
- The name of the user who edited it.
- The date and time it was last edited.
One or more of these tracked properties are populated by the underlying ArcObjects edit code (therefore, from ArcMap, ArcGIS Pro, ArcGIS Server, or ArcPy) by simply adding the tracked columns to the list of insert columns (hidden from the user, as with the objectid value) and adding the appropriate value from the stream properties. If the table is versioned (in an enterprise geodatabase), then the edit properties are concatenated to the "Adds" table row (as any other INSERT or UPDATE request would be under the versioning model).
Editor Tracking behaves the same, no matter the geodatabase, so the fact that the table is in an Oracle enterprise geodatabase is not significant, and no Oracle-specific mechanisms are involved (beyond the core multiversion editing functionality).