How to start SQLT XTRACT on a SQL that executes at night?
Someone asked recently for an easy way to execute SQLT XTRACT on a SQL that happens to execute only out of a daily batch process. This person wanted to use SQLT to capture dynamic performance data from GV$ views, so method XTRACT would help. The problem was then “how to get SQLT XTRACT to start lets say at 10pm when I leave the office at 5:30pm?”.
Starting with SQLT 220.127.116.11, all main methods (including XTRACT) take the SQLTXPLAIN password as an inline parameter instead of an ACCEPT command, so we can now easily execute at 5:30pm a script where we pass to XTRACT both the SQL_ID and the SQLTXPLAIN password. In example below such password is sqltxplain (lower case):
-- script.sql which executes SQLT XTRACT with a delay of 4.5 hours host sleep 4.5h start run/sqltxtract.sql 51x6yr9ym5hdc sqltxplain