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.