Is SQLT safe to run in production? I am debugging poor query performance for my application and recently came across the SQLT tool. The XTRXEC method combines XTRACT and XECUTE and it seems like this provides more info then XTRACT alone. However, one of the statements that I want to investigate is an Insert. Is it safe to run XTRXEC in a live production environment or will the XECUTE try to actually do the insert? If that's the case is it safe to do the XTRACT in production?
This is from the sqlt instruction file itself:

"For statements that modify data, i.e. INSERT/UPDATE/DELETE, a savepoint is created prior to statement execution and the transaction is rolled back to the savepoint at the conclusion of the session. For further information regarding SAVEPOINT please consult the Oracle Concepts reference manual".

This means if you are using XECUTE method, the data it inserted during execution will be rolled back at the end of execution.
If you are running this in a production system with thousands of transactions per second, you might want to consider the additional load this insert/rollback will put on the system.

Hope this helps :)