I am in the process of writing a python script that generates a summary of number of inserts, updates and deletes for every feature class updated in every version in the GDB. We intend to use this as part of our QC efforts, as we have student interns who help with the data updates.
The script does this by querying the following tables:
SDE.VERSIONS
SDE.STATE_LINEAGES
SDE.MVTABLES_MODIFIED
SDE.TABLE_REGISTRY
SDE.A/D TABLES
We are running ArcSDE 9.3 on Oracle 10g, and hope to upgrade to ArcSDE 10.1 in the near future.
I remember reading that some of the back-end SDE system tables have changed in 10, and am wondering if any of these tables were part of that change.