Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

How to start SQLT XTRACT on a SQL that executes at night?

with one comment

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, 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

Written by Carlos Sierra

June 6, 2012 at 11:41 am


One Response

Subscribe to comments with RSS.

  1. Gracias, me ayudo mucho!

    Jhonatan Aguilar Garcia

    September 24, 2017 at 3:49 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: