Application with Oldest Transaction


 
Snapshot Level
Database

 
Logical Data Grouping
dbase

 
Monitor Switch
Basic

Resettable

No

 

Element Name
Element Type

appl_id_oldest_xact
information

 

Description:  The application ID (agent ID from the application snapshot) of the application that has the oldest transaction.

Usage:  This element can help you determine which application has the oldest active transaction and is therefore holding the most log space in the database. This application can be forced to free up log space. You should examine the application to determine if it could be modified to commit more frequently.