First Login to the server
Go to directory where sqlt tool is installed
There u will find one directory name sqlt.
Inside sqlt directory you will find directories like RUN,INPUT etc...
Go to INPUT directory
Create one sql file.. e.g. q1.sql
Just paste the Query for which you want the sqltxtplain to be generated and save it in q1.sql
Come back to sqlt directory. sqltNow connect as apps user (sqlplus apps/apps)
Just run the following command.
Command to generate sqltxplan plan for given or provided sql
sql > start run/sqltxplain.sql input/q1.sqlIt will prompt for Enter value for sqlt_method: just give XPLAINThen it will prompt for SQLTXPLAIN password (required)
Password for user SQLTXPLAIN: Give SQLTXPLAIN as password
Then one Zip file will get created.
That is what SQLTXTPLAIN!!!
