What are these columns in V$ACTIVE_SESSION_HISTORY – TM_DELTA_TIME, TM_DELTA_CPU_TIME and TM_DELTA_DB_TIME?
TM_DELTA_TIME – Sounds like a certain Birmingham-based Oracle expert watching a Chuck Norris film…
What does the doco say?
- TM_DELTA_TIME – Time interval (in microseconds) over which TM_DELTA_CPU_TIME and TM_DELTA_DB_TIME are accumulated
- TM_DELTA_CPU_TIME – Amount of time this session spent on CPU over the last TM_DELTA_TIME microseconds
- TM_DELTA_DB_TIME – Amount of time spent by this session in database calls over the last TM_DELTA_TIME microseconds
Need a reminder on TIME MODEL STATISTICS?
The most important of the time model statistics is DB time.