sqlt之一 安装篇

sqlt的安装14:44:22 sys@orcl> @/tmp/sqlt/install/sqcreate.sql14:44:37 sys@orcl> SET DEF ON ECHO ON TERM OFF null "";        zip warning: name not matched: *_sq*.logzip error: Nothing to do! (SQLT_installation_logs_archive.zip)        zip warning: name not matched: *_ta*.logzip error: Nothing to do! (SQLT_installation_logs_archive.zip)PL/SQL procedure successfully completed.Elapsed: 00:00:00.01Specify optional Connect Identifier (as per Oracle Net)Include "@" symbol, ie. @PRODIf not applicable, enter nothing and hit the "Enter" key.You *MUST* provide a connect identifier when installingSQLT in a Pluggable Database in 12cThis connect identifier is only used while exporting SQLTrepository everytime you execute one of the main methods.Optional Connect Identifier (ie: @PROD): @ORCLPL/SQL procedure successfully completed.Elapsed: 00:00:00.01PL/SQL procedure successfully completed.Elapsed: 00:00:00.01Define SQLTXPLAIN password (hidden and case sensitive).Elapsed: 00:00:00.04Password for user SQLTXPLAIN: Re-enter password: PL/SQL procedure successfully completed.Elapsed: 00:00:00.00... please waitTABLESPACE                     FREE_SPACE_MB------------------------------ -------------USERS                                  32717Elapsed: 00:00:00.08Specify PERMANENT tablespace to be used by SQLTXPLAIN.Tablespace name is case sensitive.Default tablespace [UNKNOWN]: USERSPL/SQL procedure successfully completed.Elapsed: 00:00:00.02... please waitTABLESPACE------------------------------TEMPElapsed: 00:00:00.02Specify TEMPORARY tablespace to be used by SQLTXPLAIN.Tablespace name is case sensitive.Temporary tablespace [UNKNOWN]: TEMPPL/SQL procedure successfully completed.Elapsed: 00:00:00.01Specify TEMPORARY tablespace to be used by SQLTXPLAIN.Tablespace name is case sensitive.Temporary tablespace [UNKNOWN]: TEMPPL/SQL procedure successfully completed.Elapsed: 00:00:00.01The main application user of SQLT is the schemaowner that issued the SQL to be analyzed.For example, on an EBS application you wouldenter APPS.You will not be asked to enter its password.To add more SQLT users after this installationis completed simply grant them the SQLT_USER_ROLErole.Main application user of SQLT: SCOTTPL/SQL procedure successfully completed.Elapsed: 00:00:00.01SQLT can make extensive use of licensed featuresprovided by the Oracle Diagnostic and the OracleTuning Packs, including SQL Tuning Advisor (STA),SQL Monitoring and Automatic Workload Repository(AWR).To enable or disable access to these featuresfrom the SQLT tool enter one of the followingvalues 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 licensesOracle Pack license [T]: PL/SQL procedure successfully completed.Elapsed: 00:00:00.03PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00TADOBJ completed.PL/SQL procedure successfully completed.Elapsed: 00:00:00.01SQDOLD completed. Ignore errors from this script  adding: 141221144437_01_sqcreate.log (deflated 90%)Elapsed: 00:00:00.00SQCUSR completed. Some errors are expected.Procedure created.Elapsed: 00:00:00.90No errors.  adding: 141221145049_02_sqcusr.log (deflated 88%)TAUTLTEST completed.  adding: 141221145055_09_tautltest.log (deflated 71%)Elapsed: 00:00:00.00SQUTLTEST completed.  adding: 141221145056_10_squtltest.log (deflated 71%)Elapsed: 00:00:00.00no rows selectedElapsed: 00:00:00.01TACOBJ completed.  adding: 141221145056_03_tacobj.log (deflated 87%)14:51:05 sys@orcl> PRO Dropping Libraries for TRCADropping Libraries for TRCA14:51:05 sys@orcl> SET TERM OFF;Elapsed: 00:00:00.00Elapsed: 00:00:00.00Elapsed: 00:00:00.01tool_repository_schema: "SQLTXPLAIN"tool_administer_schema: "SQLTXADMIN"role_name: "SQLT_USER_ROLE"Creating ProceduresCreating Package Specs TRCA$GNo errors.Creating Package Specs TRCA$PNo errors.Creating Package Specs TRCA$TNo errors.Creating Package Specs TRCA$INo errors.Creating Package Specs TRCA$ENo errors.Creating Package Specs TRCA$RNo errors.Creating Package Specs TRCA$XNo errors.Creating ViewsCreating Package Body TRCA$GNo errors.Creating Package Body TRCA$PNo errors.Creating Package Body TRCA$TNo errors.Creating Package Body TRCA$INo errors.Creating Package Body TRCA$ENo errors.Creating Package Body TRCA$RNo errors.Creating Package Body TRCA$XNo errors.Creating Grants on LibrariesTool Version----------------12.1.10Elapsed: 00:00:00.02Install Date----------------20141221Elapsed: 00:00:00.00Directories--------------------------------------------------------------------------------------------------------------------------------TRCA$INPUT1(VALID)      /u01/app/oracle/diag/rdbms/orcl/orcl/traceTRCA$INPUT2(VALID)      /u01/app/oracle/diag/rdbms/orcl/orcl/traceTRCA$STAGE(VALID)       /u01/app/oracle/diag/rdbms/orcl/orcl/traceuser_dump_dest          /u01/app/oracle/diag/rdbms/orcl/orcl/tracebackground_dump_dest    /u01/app/oracle/diag/rdbms/orcl/orcl/traceElapsed: 00:00:00.08Libraries--------------------------------------------------------------------------------------------------------------------------------VALID PACKAGE TRCA$I /* $Header: 224270.1 tacpkgi.pks 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE TRCA$E /* $Header: 224270.1 tacpkge.pks 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE TRCA$G /* $Header: 224270.1 tacpkgg.pks 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE TRCA$P /* $Header: 224270.1 tacpkgp.pks 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE TRCA$R /* $Header: 224270.1 tacpkgr.pks 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE TRCA$T /* $Header: 224270.1 tacpkgt.pks 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE TRCA$X /* $Header: 224270.1 tacpkgx.pks 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE BODY TRCA$I /* $Header: 224270.1 tacpkgi.pkb 11.4.5.1 2012/11/27 carlos.sierra $ */VALID PACKAGE BODY TRCA$E /* $Header: 224270.1 tacpkge.pkb 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE BODY TRCA$G /* $Header: 224270.1 tacpkgg.pkb 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE BODY TRCA$P /* $Header: 224270.1 tacpkgp.pkb 11.4.5.8 2013/05/10 carlos.sierra $ */VALID PACKAGE BODY TRCA$R /* $Header: 224270.1 tacpkgr.pkb 11.4.5.0 2012/11/21 carlos.sierra $ */VALID PACKAGE BODY TRCA$T /* $Header: 224270.1 tacpkgt.pkb 11.4.5.7 2013/04/05 carlos.sierra $ */VALID PACKAGE BODY TRCA$X /* $Header: 224270.1 tacpkgx.pkb 11.4.5.0 2012/11/21 carlos.sierra $ */Elapsed: 00:00:00.15TACPKG completed.PL/SQL procedure successfully completed.Elapsed: 00:00:00.02  adding: 141221145105_04_tacpkg.log (deflated 85%)Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00SQCOBJ completed. Some errors are expected.  adding: 141221145133_05_sqcobj.log (deflated 93%)PL/SQL procedure successfully completed.Elapsed: 00:00:00.00SQLT can make extensive use of licensed featuresprovided by the Oracle Diagnostic and the OracleTuning Packs, including SQL Tuning Advisor (STA),SQL Monitoring, Automatic Workload Repository(AWR) and SQL Tuning Sets (STS).To enable or disable access to these featuresfrom the SQLT tool enter one of the followingvalues 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 licensespack_license: ""enable_tuning_pack_accessPL/SQL procedure successfully completed.Elapsed: 00:00:00.02Specify optional Connect Identifier (as per Oracle Net)Include "@" symbol, ie. @PRODIf not applicable, enter nothing and hit the "Enter" keyconnect_identifier: "@ORCL"PL/SQL procedure successfully completed.Elapsed: 00:00:00.01Table truncated.Elapsed: 00:00:00.02PL/SQL procedure successfully completed.Elapsed: 00:00:00.06PL/SQL procedure successfully completed.Elapsed: 00:00:00.01PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.02PL/SQL procedure successfully completed.Elapsed: 00:00:00.01PL/SQL procedure successfully completed.Elapsed: 00:00:00.00Procedure created.Elapsed: 00:00:00.85No errors.Table truncated.Elapsed: 00:00:00.00PL/SQL procedure successfully completed.Elapsed: 00:00:00.01Procedure dropped.Elapsed: 00:00:00.06Commit complete.Elapsed: 00:00:00.01SQSEED completed.  adding: 141221145329_07_sqseed.log (deflated 85%)PL/SQL procedure successfully completed.Elapsed: 00:00:00.00... dropping packages for SQLT... creating package specs for SQLT$Asys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$a;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Csys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$c;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Dsys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$d;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Esys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$e;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Hsys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$h;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Isys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$i;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Msys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$m;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Rsys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$r;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Ssys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$s;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package specs for SQLT$Tsys@orcl> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$t;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating viewsPL/SQL procedure successfully completed.Elapsed: 00:00:00.00... creating package body for SQLT$Asys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$a;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Csys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$c;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Dsys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$d;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Esys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$e;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Hsys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$h;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Isys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$i;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Msys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$m;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Rsys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$r;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Ssys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$s;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;... creating package body for SQLT$Tsys@orcl> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$t;No errors.sys@orcl> --sys@orcl> SET TERM ON ECHO OFF;Creating Grants on Packages ...LIBRARIES----------------------------------------------------------------VALID   PACKAGE      12.1.10  SQLT$AVALID   PACKAGE      12.1.10  SQLT$CVALID   PACKAGE      12.1.10  SQLT$DVALID   PACKAGE      12.1.10  SQLT$EVALID   PACKAGE      12.1.10  SQLT$HVALID   PACKAGE      12.1.10  SQLT$IVALID   PACKAGE      12.1.10  SQLT$MVALID   PACKAGE      12.1.10  SQLT$RVALID   PACKAGE      12.1.10  SQLT$SVALID   PACKAGE      12.1.10  SQLT$TVALID   PACKAGE      11.4.5.0 TRCA$EVALID   PACKAGE      11.4.5.0 TRCA$GVALID   PACKAGE      11.4.5.0 TRCA$IVALID   PACKAGE      11.4.5.0 TRCA$PVALID   PACKAGE      11.4.5.0 TRCA$RVALID   PACKAGE      11.4.5.0 TRCA$TVALID   PACKAGE      11.4.5.0 TRCA$XVALID   PACKAGE BODY 12.1.10  SQLT$AVALID   PACKAGE BODY 12.1.10  SQLT$CVALID   PACKAGE BODY 12.1.10  SQLT$DVALID   PACKAGE BODY 12.1.10  SQLT$ELIBRARIES----------------------------------------------------------------VALID   PACKAGE BODY 12.1.10  SQLT$HVALID   PACKAGE BODY 12.1.10  SQLT$IVALID   PACKAGE BODY 12.1.10  SQLT$MVALID   PACKAGE BODY 12.1.10  SQLT$RVALID   PACKAGE BODY 12.1.10  SQLT$SVALID   PACKAGE BODY 12.1.10  SQLT$TVALID   PACKAGE BODY 11.4.5.0 TRCA$EVALID   PACKAGE BODY 11.4.5.0 TRCA$GVALID   PACKAGE BODY 11.4.5.1 TRCA$IVALID   PACKAGE BODY 11.4.5.8 TRCA$PVALID   PACKAGE BODY 11.4.5.0 TRCA$RVALID   PACKAGE BODY 11.4.5.7 TRCA$TVALID   PACKAGE BODY 11.4.5.0 TRCA$XElapsed: 00:00:00.18Elapsed: 00:00:00.06Deleting CBO statistics for SQLTXPLAIN objects ...14:54:55    0 sqlt$a: -> delete_sqltxplain_stats14:55:02    7 sqlt$a: <- delete_sqltxplain_statsPL/SQL procedure successfully completed.Elapsed: 00:00:07.30SQCPKG completed.  adding: 141221145330_08_sqcpkg.log (deflated 80%)Elapsed: 00:00:00.00TAUTLTEST completed.  adding: 141221145503_09_tautltest.log (deflated 61%)Elapsed: 00:00:00.01SQUTLTEST completed.  adding: 141221145503_10_squtltest.log (deflated 62%)SQLT users must be granted SQLT_USER_ROLE before using this tool.SQCREATE completed. Installation completed successfully.