Installation

Installation

Initial Installation

cd ~/sqlt/install
sqlplus "/ as sysdba" @sqcreate.sql
This script will create the SQLTXPLAIN user and associated objects. You will have to answer some questions about paths and tablespaces.

Silent Installation

cd ~/sqlt/install
sqlplus "/ as sysdba"

START sqdrop.sql
START sqcsilent2.sql '' xplain USERS TEMP 'SCHEMA' T
REM To speed up execution, run these commands:
EXEC sqltxplain.sqlt$a.set_param('test_case_builder', 'N');
EXEC sqltxplain.sqlt$a.set_param('sta_time_limit_secs', '120');

Adding ability for another schema to access SQLT facilities

The initial setup of SQLT on a database allows access to 1 schema. To add access for additional schemas, use this command.
sqlplus system@database
GRANT SQLT_USER_ROLE  TO &newuser.;

Running SQLT

... to do ...