Can I read Optimize Systems with SQLTRACE Guide on EtoBox?
Optimize Systems with SQLTRACE Guide by Viorel Panaite is a document available to read on EtoBox.
What is Optimize Systems with SQLTRACE Guide about?
SQLTRACE is a feature in IBM Informix that collects SQL statement history information including statistics, resource usage, and details of the statement. It allows querying and drill-down of transaction information for troubleshooting and optimization. SQLTRACE data is stored only in memory, so it needs to be periodically saved to permanent storage for later analysis. The level of details collected can be set to low, medium, or high depending on the performance impact needed.
- Author
- Viorel Panaite
- Language
- EN