We need to know the timestamp of the last update/insert/delete to a
table partition (release 9.2.0). The goal is to avoid the resource
expense of repeatedly exporting huge partitions when their data has
not changed. Periodic monitoring of "write" statistics in
v$segment_statistics has produced inconsistent and unexplainable
results. Auditing does not address partitions. Does anyone know if
there might be such timestamp info in segment headers, and whether
Oracle externalizes this info in some way?
TIA,
Dave
Received on Thu Oct 21 2004 - 09:51:29 CDT
