SQLT工具的安装过程

安装步骤如下：

 [oracle@haoxy u01]$ unzip sqltfor10.zip -d sqltfor10

[oracle@haoxy u01]$ cd sqltfor10/sqlt/

[oracle@haoxy sqlt]$ ls

doc  input  install  run  sqlt_instructions.html  utl

[oracle@haoxy sqlt]$ cd install/

若之前安装过则执行下面命令

# sqlplus / as sysdba
SQL> start sqdrop.sql

否则执行

# cd sqlt/install
SQL>START sqcreate.sql

首先要创建一个专门SQLT 用户和临时表空间

SQL>create user sqlter identified by sqlter;

临时表空间

SQL> CREATE TEMPORARY TABLESPACE temp001

  2  TEMPFILE '/u01/app/oradata/hxy/temp001.dbf'
  3  SIZE 200m
  4  AUTOEXTEND ON
  5  NEXT 32m MAXSIZE 2048m
  6  EXTENT MANAGEMENT LOCAL;

开始安装

SQL> START sqcreate.sql

PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.

RDBMS_RELEASE RDBMS_VERSION
---------------------------------------------------------------------------------------------
         11.2 11.2.0.1.0

no rows selected

Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key.
This connect identifier is only used while exporting SQLT
repository everytime you execute one of the main methods.

Optional Connect Identifier (ie: @PROD): @hxy  

PL/SQL procedure successfully completed.
Define SQLTXPLAIN password (hidden and case sensitive).

Password for user SQLTXPLAIN: 
Re-enter password:   《-----SQLt用户的密码。
PL/SQL procedure successfully completed.

... please wait

no rows selected

Specify PERMANENT tablespace to be used by SQLTXPLAIN.
Tablespace name is case sensitive.
Default tablespace [UNKNOWN]: USERS  

PL/SQL procedure successfully completed.

... please wait

TABLESPACE
------------------------------
TEMP
TEMP001

Specify TEMPORARY tablespace to be used by SQLTXPLAIN.

Tablespace name is case sensitive.

Temporary tablespace [UNKNOWN]: TEMP001
PL/SQL procedure successfully completed.

The main application user of SQLT is the schema

owner that issued the SQL to be analyzed.
For example, on an EBS application you would
enter APPS.
You will not be asked to enter its password.
To add more SQLT users after this installation
is completed simply grant them the SQLT_USER_ROLE
role.

Main application user of SQLT: sqlter    ----之前创建的专用用户

PL/SQL procedure successfully completed.


SQLT can make extensive use of licensed features
provided by the Oracle Diagnostic and the Oracle
Tuning Packs, including SQL Tuning Advisor (STA),
SQL Monitoring and Automatic Workload Repository
(AWR).
To enable or disable access to these features
from the SQLT tool enter one of the following
values when asked:

"T" if you have license for Diagnostic and Tuning
"D" if you have license only for Oracle Diagnostic
"N" if you do not have these two licenses

Oracle Pack license [T]: T

PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.

TADOBJ completed.

PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
RDBMS_RELEASE RDBMS_VERSION
---------------------------------------------------------------------------------------------
         11.2 11.2.0.1.0

no rows selected

SQDOLD completed. Ignore errors from this script

SQCUSR completed. Some errors are expected.
Procedure created.
No errors.
TAUTLTEST completed.

SQUTLTEST completed.

。。。。。。。

eleting CBO statistics for SQLTXPLAIN objects ...
02:02:04 sqlt$a: -> delete_sqltxplain_stats
02:02:24 sqlt$a: PL/SQL procedure successfully completed.
SQCPKG completed.
TAUTLTEST completed.
SQUTLTEST completed.
SQLT users must be granted SQLT_USER_ROLE before using this tool.

SQCREATE completed. Installation completed successfully.

最后授予sqlter访问权限

SQL> grant SQLT_USER_ROLE to sqlter;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24492954/viewspace-1129890/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24492954/viewspace-1129890/