|
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 (which corresponds to the agent_id value 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.
There are times when there is not a transaction holding up logging, or the oldest transaction does not have an application ID (for example, indoubt transaction or inactive transaction). In these cases, this application's ID is not returned in the data stream.