Statistics of the running queries are stored in shared segment. To avoid shared segment becoming full, the statistics is removed as soon as the query is deallocated. I believe If the query takes longer than 60 seconds, the end statistics will be written to repository by default. This time duration of the query to be written can be configured.
In addition, the monitored queries are kept in the shared segment even after the query is deallocated. You can start monitoring the query by issuing get statistics for qid <qid> or any other equivalent command involving query id. However, if the query takes a very short time, it is possible that query could complete before you start monitoring it. Thanks, Selva -----Original Message----- From: Yang, Peng-Peng <[email protected]> Sent: Sunday, July 29, 2018 9:55 PM To: [email protected] Subject: How to analyze the completed sql statement Hi Trafodioneers, Sometimes we need to analyze the sql running at the end, how can we get the statistics of the completed sql? Or configure sql statistics to stay longer in the offender? Not "get statistics for qid current;", Regards, Pengpeng
