Oracle SQL Tuning Tools and Tips

SQL Tuning, eAdam, eDB360, SQLT, SQLHC

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

leave a 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 11.4.4.6, 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

Posted in SQLTXPLAIN (SQLT)

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,414 other followers

%d bloggers like this: