OpenEdge Version 11.0 introduced two new log entry types for use in tracing TEMP-TABLE design and usage statistics. Please visit the OpenEdge documentation for more details about both these log entry types.
Temp-Tables LOG-ENTRY-TYPE
The temp-tables log entry type enables specific logging for temp-tables so that application developers and technical support engineers can gather more information about the temp-tables used by an application.
This log entry type logs the following information:
- Temp-table name
- Temp-table Unique ID
- Number of indexes created for a temp-table
- Number of times the EMPTY TEMP-TABLE statement or EMPTY-TEMP-TABLE method is executed
- Procedure or class name and line where the temp-table was created, deleted or emptied
- Number of records and record size
TTStats LOG-ENTRY-TYPE
The statistics for temp-tables (available in _TableStat and IndexStat virtual system tables) are lost once the temp-tables and its indexes are deleted. Therefore there is a need to collect the statistics for usage of temp-tables. There are two ways to save the table and index statistics for temp-tables. It can be done through the log entry type TTStats or by archiving the statistics in the TableStatHistory/IndexStatHistory temp-tables. The data from these tables cab be written to an XML file before ending the session.
The new TTStats log entry type enables logging of temp-table usage statistics in the corresponding client or server log files.
If TTStats is enabled with a logging level of 2 or greater, and the startup parameter -tttablerangesize is set to a value greater than 0, the AVM logs an entry that contains temp-table statistics and includes the table name, and the procedure or class name. The AVM writes the data to the log file before the temp-table gets deleted.
If TTStats is enabled with a logging level of 3 or greater, and the startup parameter -ttindexrangesize is set to a value greater than 0, the AVM logs an entry that contains index statistics and includes the index name, and the procedure or class name. The AVM writes the data to the log file before the index of the temp-table gets deleted.
|
