Datagaurd Health check scripts.

Primary Site Script
===============================================================================

-- This script is to be run on the Primary of a Data Guard Physical Standby Site

set echo off
set feedback off
column timecol new_value tstamp
column spool_extension new_value suffix
select to_char(sysdate,'Mondd_hhmi') timecol from sys.dual;
column output new_value dbname
select value || '_' output from v$parameter where name = 'db_name';

-- Output the results to this file

spool dg_Primary_diag_&&dbname&&tstamp
set lines 132
set pagesize 500
set numformat 999999999999999
set trim on
set trims on

-- Get the current Date

alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
set feedback on
select systimestamp from dual;

-- Primary Site Details
set heading off
set feedback off
select 'Primary Site Details' from dual;
select '********************' from dual;
set heading on
set feedback on

col db_unique_name format a15
col flashb_on format a10

select DB_UNIQUE_NAME,DATABASE_ROLE DB_ROLE,FORCE_LOGGING F_LOG,FLASHBACK_ON FLASHB_ON,LOG_MODE,OPEN_MODE,
       GUARD_STATUS GUARD,PROTECTION_MODE PROT_MODE
from v$database;

-- Current SCN - this value on the primary and standby sites where real time apply is in place should be nearly the same

set heading off
set feedback off
select 'Primary Site last generated SCN' from dual;
select '*******************************' from dual;
set heading on
set feedback on

select DB_UNIQUE_NAME,SWITCHOVER_STATUS,CURRENT_SCN from v$database;

set heading off
set feedback off
select 'Standby Site last applied SCN' from dual;
select '*****************************' from dual;
set heading on
set feedback on

select DEST_ID, APPLIED_SCN FROM v$archive_dest WHERE TARGET='STANDBY';


-- Incarnation Information
--

set heading off
set feedback off
select 'Incarnation Destination Configuration' from dual;
select '*************************************' from dual;
set heading on
set feedback on

select INCARNATION# INC#, RESETLOGS_CHANGE# RS_CHANGE#, RESETLOGS_TIME, PRIOR_RESETLOGS_CHANGE# PRIOR_RS_CHANGE#, STATUS,FLASHBACK_DATABASE_ALLOWED FB_OK from v$database_incarnation;

-- Archivelog Destination Details
--

set heading off
set feedback off
select 'Archive Destination Configuration' from dual;
select '*********************************' from dual;
set heading on
set feedback on

-- Current Archive Locations
--
 
column host_name format a30 tru
column version format a10 tru
select INSTANCE_NAME,HOST_NAME,VERSION,ARCHIVER from v$instance;

column destination format a35 wrap
column process format a7
column archiver format a8
column dest_id format 99999999
 
select DEST_ID,DESTINATION,STATUS,TARGET,ARCHIVER,PROCESS,REGISTER,TRANSMIT_MODE  
from v$archive_dest
where DESTINATION IS NOT NULL;

column name format a22
column value format a100
select NAME,VALUE from v$parameter where NAME like 'log_archive_dest%' and upper(VALUE) like 'SERVICE%';

set heading off
set feedback off
select 'Archive Destination Errors' from dual;
select '**************************' from dual;
set heading on
set feedback on

column error format a55 tru
select DEST_ID,STATUS,ERROR from v$archive_dest
where DESTINATION IS NOT NULL;

column message format a80
select MESSAGE, TIMESTAMP
from v$dataguard_status
where SEVERITY in ('Error','Fatal')
order by TIMESTAMP;

-- Redo Log configuration
-- The size of the standby redo logs must match exactly the size on the online redo logs

set heading off
set feedback off
select 'Data Guard Redo Log Configuration' from dual;
select '*********************************' from dual;
set heading on
set feedback on

select GROUP# STANDBY_GROUP#,THREAD#,SEQUENCE#,BYTES,USED,ARCHIVED,STATUS from v$standby_log order by GROUP#,THREAD#;

select GROUP# ONLINE_GROUP#,THREAD#,SEQUENCE#,BYTES,ARCHIVED,STATUS from v$log order by GROUP#,THREAD#;

-- Data Guard Parameters
--
set heading off
set feedback off
select 'Data Guard Related Parameters' from dual;
select '*****************************' from dual;
set heading on
set feedback on

column name format a30
column value format a100
select NAME,VALUE from v$parameter where NAME IN ('db_unique_name','cluster_database','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','fal_client','fal_server','log_archive_config','log_archive_trace','log_archive_max_processes','archive_lag_target','remote_login_password_file','redo_transport_user') order by name;


-- Redo Shipping Progress

set heading off
set feedback off
select 'Data Guard Redo Shipping Progress' from dual;
select '*********************************' from dual;
set heading on
set feedback on

select systimestamp from dual;

column client_pid format a10
select PROCESS,STATUS,CLIENT_PROCESS,CLIENT_PID,THREAD#,SEQUENCE#,BLOCK#,ACTIVE_AGENTS,KNOWN_AGENTS
from v$managed_standby  order by CLIENT_PROCESS,THREAD#,SEQUENCE#;

host sleep 10

select systimestamp from dual;

select PROCESS,STATUS,CLIENT_PROCESS,CLIENT_PID,THREAD#,SEQUENCE#,BLOCK#,ACTIVE_AGENTS,KNOWN_AGENTS
from v$managed_standby  order by CLIENT_PROCESS,THREAD#,SEQUENCE#;

host sleep 10

select systimestamp from dual;

select PROCESS,STATUS,CLIENT_PROCESS,CLIENT_PID,THREAD#,SEQUENCE#,BLOCK#,ACTIVE_AGENTS,KNOWN_AGENTS
from v$managed_standby  order by CLIENT_PROCESS,THREAD#,SEQUENCE#;


set heading off
set feedback off
select 'Data Guard Errors in the Last Hour' from dual;
select '**********************************' from dual;
set heading on
set feedback on

select TIMESTAMP,SEVERITY,ERROR_CODE,MESSAGE from v$dataguard_status where timestamp > systimestamp-1/24;
spool off

================================================================================

Standby Site Script
================================================================================

-- This script is to be run on the Standby of a Data Guard Physical Standby Site

set echo off
set feedback off
column timecol new_value tstamp
column spool_extension new_value suffix
select to_char(sysdate,'Mondd_hhmi') timecol from sys.dual;
column output new_value dbname
select value || '_' output from v$parameter where name = 'db_name';

-- Output the results to this file

spool dg_Standby_diag_&&dbname&&tstamp
set lines 132
set pagesize 500
set numformat 999999999999999
set trim on
set trims on

-- Get the current Date

set feedback on
select systimestamp from dual;

-- Standby Site Details
set heading off
set feedback off
select 'Standby Site Details' from dual;
select '********************' from dual;
set heading on
set feedback on

col db_unique_name format a15
col flashb_on format a10

select DB_UNIQUE_NAME,DATABASE_ROLE DB_ROLE,FORCE_LOGGING F_LOG,FLASHBACK_ON FLASHB_ON,LOG_MODE,OPEN_MODE,
       GUARD_STATUS GUARD,PROTECTION_MODE PROT_MODE
from v$database;

-- Current SCN - this value on the primary and standby sites where real time apply is in place should be nearly the same

select DB_UNIQUE_NAME,SWITCHOVER_STATUS,CURRENT_SCN from v$database;

-- Incarnation Information
--

set heading off
set feedback off
select 'Incarnation Destination Configuration' from dual;
select '*************************************' from dual;
set heading on
set feedback on

select INCARNATION# INC#, RESETLOGS_CHANGE# RS_CHANGE#, RESETLOGS_TIME, PRIOR_RESETLOGS_CHANGE# PRIOR_RS_CHANGE#, STATUS,FLASHBACK_DATABASE_ALLOWED FB_OK from v$database_incarnation;


set heading off
set feedback off
select 'Archive Destination Configuration' from dual;
select '*********************************' from dual;
set heading on
set feedback on
-- Current Archive Locations
--
 
column host_name format a30 tru
column version format a10 tru
select INSTANCE_NAME,HOST_NAME,VERSION,ARCHIVER from v$instance;

column destination format a35 wrap
column process format a7
column archiver format a8
column dest_id format 99999999
 
select DEST_ID,DESTINATION,STATUS,TARGET,ARCHIVER,PROCESS,REGISTER,TRANSMIT_MODE  
from v$archive_dest
where DESTINATION IS NOT NULL;

column name format a22
column value format a100
select NAME,VALUE from v$parameter where NAME like 'log_archive_dest%' and upper(VALUE) like 'SERVICE%';

set heading off
set feedback off
select 'Archive Destination Errors' from dual;
select '**************************' from dual;
set heading on
set feedback on

column error format a55 tru
select DEST_ID,STATUS,ERROR from v$archive_dest
where DESTINATION IS NOT NULL;

column message format a80
select MESSAGE, TIMESTAMP
from v$dataguard_status
where SEVERITY in ('Error','Fatal')
order by TIMESTAMP;

-- Redo Log configuration
-- The size of the standby redo logs must match exactly the size on the online redo logs

set heading off
set feedback off
select 'Data Guard Redo Log Configuration' from dual;
select '*********************************' from dual;
set heading on
set feedback on

select GROUP# STANDBY_GROUP#,THREAD#,SEQUENCE#,BYTES,USED,ARCHIVED,STATUS from v$standby_log order by GROUP#,THREAD#;

select GROUP# ONLINE_GROUP#,THREAD#,SEQUENCE#,BYTES,ARCHIVED,STATUS from v$log order by GROUP#,THREAD#;

-- Data Guard Parameters
--
set heading off
set feedback off
select 'Data Guard Related Parameters' from dual;
select '*****************************' from dual;
set heading on
set feedback on

column name format a30
column value format a100
select NAME,VALUE from v$parameter where NAME IN ('db_unique_name','cluster_database','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','fal_client','fal_server','log_archive_config','log_archive_trace','log_archive_max_processes','archive_lag_target','remote_login_password_file','redo_transport_user') order by name;

-- Managed Recovery State

set heading off
set feedback off
select 'Data Guard Apply Status' from dual;
select '***********************' from dual;
set heading on
set feedback on

select systimestamp from dual;

column client_pid format a10
select PROCESS,STATUS,CLIENT_PROCESS,CLIENT_PID,THREAD#,SEQUENCE#,BLOCK#,ACTIVE_AGENTS,KNOWN_AGENTS
from v$managed_standby  order by CLIENT_PROCESS,THREAD#,SEQUENCE#;

host sleep 10

select systimestamp from dual;

select PROCESS,STATUS,CLIENT_PROCESS,CLIENT_PID,THREAD#,SEQUENCE#,BLOCK#,ACTIVE_AGENTS,KNOWN_AGENTS
from v$managed_standby  order by CLIENT_PROCESS,THREAD#,SEQUENCE#;

host sleep 10

select systimestamp from dual;

select PROCESS,STATUS,CLIENT_PROCESS,CLIENT_PID,THREAD#,SEQUENCE#,BLOCK#,ACTIVE_AGENTS,KNOWN_AGENTS
from v$managed_standby  order by CLIENT_PROCESS,THREAD#,SEQUENCE#;


set heading off
set feedback off
select 'Data Guard Apply Lag' from dual;
select '********************' from dual;
set heading on
set feedback on

column name format a12
column lag_time format a20
column datum_time format a20
column time_computed format a20
SELECT NAME, VALUE LAG_TIME, DATUM_TIME, TIME_COMPUTED
from V$DATAGUARD_STATS where name like 'apply lag';

-- If there is a lag remove the comment for the select below
--SELECT * FROM V$STANDBY_EVENT_HISTOGRAM WHERE NAME = 'apply lag'  AND COUNT > 0;

set heading off
set feedback off
select 'Data Guard Gap Problems' from dual;
select '***********************' from dual;
set heading on
set feedback on

select * from v$archive_gap;

set heading off
set feedback off
select 'Data Guard Errors in the Last Hour' from dual;
select '**********************************' from dual;
set heading on
set feedback on

select TIMESTAMP,SEVERITY,ERROR_CODE,MESSAGE from v$dataguard_status where timestamp > systimestamp-1/24;
spool off

Enq High water mark contention

High water mark is the maximum amount of database blocks used so far by a segment. This mark cannot be reset by delete operations.

When there is a lob column in any table, heavy insert can cause enq high water mark contention due to increase in volume of inserts.

TRUNCATE will reset HWM

The blocks above the HWM level is free blocks, they are ready to use. exception Above the HWM when using the APPEND hint in the INSERT statement (or using DIRECT=Y in sql*loader)


We have to set the event available as below to higher value to reduce enq High water mark contention. ALTER SYSTEM SET EVENT=”44951 TRACE NAME CONTEXT FOREVER, LEVEL <1 - 1024>” scope=spfile;

Situation: Accidentally deleted millions of rows from a table

An Oracle user may accidentally delete millions of rows from a table, then issue a rollback to reverse the changes, a procedure that could take up to a few hours to complete. If there is a requirement to shut down the database without waiting for the rollback to complete, temporarily restart the database with the rollback disabled, perform some DBA tasks, then restart the database with the rollback enabled.


1. alter system set events '10513 trace name context forever, level 2'  scope=spfile;

2. shutdown abort.

3. startup

Then to restart the rollback.

4. alter system set events '10513 trace name context off' scope=spfile;

5. shutdown abort

6. startup
 

Troubleshoot Hung Database

To troubleshoot hung database

Few Tools that can help us to troubleshoot such situation:

1. OSwatcher must be installed and running on the database server.

2. Hung analyzer in 9.0.1.0 onwards is a good tool to analyze where the problem lies.

 A database can be hung due to following:

1. A network or firewall issue where users are unable to login.

2. Listener Hang.

3. RAM shortage hung. like SWAP area full.

4. 100% CPU.

5. Data Hang due to blocks.

6. A bad disk.

7. OS limit exceeded.

Steps to be followed while sitting on this kind of situation:

1. As a Top down approach. Try to figure what are the OS statistics showing. Commands that can help us figure out are:

Ø  dmesg: check error logs on the server.

Ø  tail -1000f /var/adm/messages to check errors logs on the server.

Ø  vmstat and top provides you the clear picture what resources is being consumed heavily.

Ø  Netstat –a this will give you network statistics.

2. Check alertlog for any errors.

3. Try hung analyzer. Hung analyzer will generate trace files which will provide a quick view of hang chains occurring at the time of a hang being experienced.

Sometimes, database may actually just be very slow and not actually hanging. It is therefore recommended,  where possible to get 2 hanganalyze and 2 systemstate dumps in order to determine whether processes are moving at all or whether they are "frozen".

Steps to perform Hung analyzer:

Hanganalyze

sqlplus '/ as sysdba'

oradebug setmypid

oradebug unlimit

oradebug hanganalyze 3

-- Wait one minute before getting the second hanganalyze

oradebug hanganalyze 3

oradebug tracefile_name

exit

Systemstate

sqlplus '/ as sysdba'

oradebug setmypid

oradebug unlimit

oradebug dump systemstate 266

oradebug dump systemstate 266

oradebug tracefile_name

exit

4. Check if there is any block or locks that are waiting. Remove the locks and blocks.

5. Run the AWR, ADDM and ASH report for the time period.

Once you are done to figure out what OS resource is exhausted and where the issue lies. You can try to figure out which pid is consuming the most of the resources. As per application design Kill those hung chain sessions.

If unable to do any of the following before rebouncing the database on server, run hung analyze in prelim session as mentioned below:

root> sqlplus –prelim

1. SQL> oradebug hanganalyze 3
2. Wait at least 2 minutes to give time to identify process state changes.
3. SQL> oradebug hanganalyze 3
4. Open a separate SQL session and immediately generate a system state dump.
5. SQL> alter session set events 'immediate trace name SYSTEMSTATE level 10';

SQLT installation

Steps for sqlT installation:

1.       Download the attached sqlt and upload to the server in desired location.

2.       Unzip the Sqlt.zip.

3.       Run @sqlt/install/sqcreate.sql as below:

SQL> conn / as sysdba

Connected.

SQL> @sqcreate.sql

  adding: 140204144155_01_sqcreate.log (deflated 81%)

zip error: Nothing to do! (SQLT_installation_logs_archive.zip)

PL/SQL procedure successfully completed.

Specify optional Connect Identifier (as per Oracle Net)

Include "@" symbol, ie. @PROD

If not applicable, enter nothing and hit the "Enter" key.

You *MUST* provide a connect identifier when installing

SQLT in a Pluggable Database in 12c

This connect identifier is only used while exporting SQLT

repository everytime you execute one of the main methods.

Optional Connect Identifier (ie: @PROD):

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Define SQLTXPLAIN password (hidden and case sensitive).

Password for user SQLTXPLAIN:

Re-enter password:

PL/SQL procedure successfully completed.

... please wait

Specify PERMANENT tablespace to be used by SQLTXPLAIN.

Tablespace name is case sensitive.

Default tablespace [UNKNOWN]: USERS

PL/SQL procedure successfully completed.

... please wait

Specify TEMPORARY tablespace to be used by SQLTXPLAIN.

Tablespace name is case sensitive.

Temporary tablespace [UNKNOWN]: TEMP

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: system

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.

PL/SQL procedure successfully completed.

TADOBJ completed.

PL/SQL procedure successfully completed.

SQDOLD completed. Ignore errors from this script

  adding: 140204144333_01_sqcreate.log (deflated 89%)

SQCUSR completed. Some errors are expected.

Procedure created.

No errors.

  adding: 140204144409_02_sqcusr.log (deflated 85%)

TAUTLTEST completed.

  adding: 140204144410_09_tautltest.log (deflated 60%)

SQUTLTEST completed.

  adding: 140204144410_10_squtltest.log (deflated 61%)

no rows selected

TACOBJ completed.

  adding: 140204144410_03_tacobj.log (deflated 86%)

SQL> PRO Dropping Libraries for TRCA

Dropping Libraries for TRCA

SQL> SET TERM OFF;

tool_repository_schema: "SQLTXPLAIN"

tool_administer_schema: "SQLTXADMIN"

role_name: "SQLT_USER_ROLE"

Creating Procedures

Creating Package Specs TRCA$G

No errors.

Creating Package Specs TRCA$P

No errors.

Creating Package Specs TRCA$T

No errors.

Creating Package Specs TRCA$I

No errors.

Creating Package Specs TRCA$E

No errors.

Creating Package Specs TRCA$R

No errors.

Creating Package Specs TRCA$X

No errors.

Creating Views

Creating Package Body TRCA$G

No errors.

Creating Package Body TRCA$P

No errors.

Creating Package Body TRCA$T

No errors.

Creating Package Body TRCA$I

No errors.

Creating Package Body TRCA$E

No errors.

Creating Package Body TRCA$R

No errors.

Creating Package Body TRCA$X

No errors.

Creating Grants on Libraries

Tool Version

----------------

12.1.06

Install Date

----------------

20140204

Directories

--------------------------------------------------------------------------------------------------------------------------------

TRCA$INPUT1(VALID)      /opt/app/p3isc1d6/oracle/diag/rdbms/p3isc1d6/p3isc1d6/trace

TRCA$INPUT2(VALID)      /opt/app/p3isc1d6/oracle/diag/rdbms/p3isc1d6/p3isc1d6/trace

TRCA$STAGE(VALID)       /opt/app/p3isc1d6/oracle/diag/rdbms/p3isc1d6/p3isc1d6/trace

user_dump_dest          /opt/app/p3isc1d6/oracle/diag/rdbms/p3isc1d6/p3isc1d6/trace

background_dump_dest    /opt/app/p3isc1d6/oracle/diag/rdbms/p3isc1d6/p3isc1d6/trace

Libraries

--------------------------------------------------------------------------------------------------------------------------------

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 $ */

TACPKG completed.

PL/SQL procedure successfully completed.

  adding: 140204144416_04_tacpkg.log (deflated 80%)

PL/SQL procedure successfully completed.

SQCOBJ completed. Some errors are expected.

  adding: 140204144531_05_sqcobj.log (deflated 93%)

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, Automatic Workload Repository

(AWR) and SQL Tuning Sets (STS).

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

pack_license: "T"

enable_tuning_pack_access

PL/SQL procedure successfully completed.

Specify optional Connect Identifier (as per Oracle Net)

Include "@" symbol, ie. @PROD

If not applicable, enter nothing and hit the "Enter" key

connect_identifier: ""

PL/SQL procedure successfully completed.

Table truncated.

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.

Procedure created.

No errors.

Table truncated.

PL/SQL procedure successfully completed.

Procedure dropped.

Commit complete.

SQSEED completed.

  adding: 140204144601_07_sqseed.log (deflated 82%)

PL/SQL procedure successfully completed.

... dropping packages for SQLT

... creating package specs for SQLT$A

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$C

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$D

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$E

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$H

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$I

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$M

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$R

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$S

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package specs for SQLT$T

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating views

PL/SQL procedure successfully completed.

... creating package body for SQLT$A

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$C

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$D

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$E

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$H

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$I

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$M

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$R

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$S

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

... creating package body for SQLT$T

SQL> SHOW ERRORS;

No errors.

SQL> --

SQL> SET TERM ON ECHO OFF;

Creating Grants on Packages ...

LIBRARIES

----------------------------------------------------------------

VALID   PACKAGE      12.1.06  SQLT$A

VALID   PACKAGE      11.4.5.0 SQLT$C

VALID   PACKAGE      12.1.06  SQLT$D

VALID   PACKAGE      12.1.03  SQLT$E

VALID   PACKAGE      11.4.5.0 SQLT$H

VALID   PACKAGE      12.1.04  SQLT$I

VALID   PACKAGE      11.4.5.0 SQLT$M

VALID   PACKAGE      12.1.03  SQLT$R

VALID   PACKAGE      11.4.5.0 SQLT$S

VALID   PACKAGE      11.4.5.6 SQLT$T

VALID   PACKAGE      11.4.5.0 TRCA$E

VALID   PACKAGE      11.4.5.0 TRCA$G

VALID   PACKAGE      11.4.5.0 TRCA$I

VALID   PACKAGE      11.4.5.0 TRCA$P

VALID   PACKAGE      11.4.5.0 TRCA$R

VALID   PACKAGE      11.4.5.0 TRCA$T

VALID   PACKAGE      11.4.5.0 TRCA$X

VALID   PACKAGE BODY 12.1.06  SQLT$A

VALID   PACKAGE BODY 12.1.03  SQLT$C

VALID   PACKAGE BODY 12.1.06  SQLT$D

VALID   PACKAGE BODY 12.1.03  SQLT$E

LIBRARIES

----------------------------------------------------------------

VALID   PACKAGE BODY 12.1.06  SQLT$H

VALID   PACKAGE BODY 12.1.05  SQLT$I

VALID   PACKAGE BODY 12.1.06  SQLT$M

VALID   PACKAGE BODY 12.1.06  SQLT$R

VALID   PACKAGE BODY 11.4.5.0 SQLT$S

VALID   PACKAGE BODY 12.1.06  SQLT$T

VALID   PACKAGE BODY 11.4.5.0 TRCA$E

VALID   PACKAGE BODY 11.4.5.0 TRCA$G

VALID   PACKAGE BODY 11.4.5.1 TRCA$I

VALID   PACKAGE BODY 11.4.5.8 TRCA$P

VALID   PACKAGE BODY 11.4.5.0 TRCA$R

VALID   PACKAGE BODY 11.4.5.7 TRCA$T

VALID   PACKAGE BODY 11.4.5.0 TRCA$X

Deleting CBO statistics for SQLTXPLAIN objects ...

14:47:54    0 sqlt$a: -> delete_sqltxplain_stats

14:47:57    3 sqlt$a: <- delete_sqltxplain_stats

PL/SQL procedure successfully completed.

SQCPKG completed.

  adding: 140204144615_08_sqcpkg.log (deflated 80%)

TAUTLTEST completed.

  adding: 140204144757_09_tautltest.log (deflated 59%)

SQUTLTEST completed.

  adding: 140204144757_10_squtltest.log (deflated 59%)

SQLT users must be granted SQLT_USER_ROLE before using this tool.

SQCREATE completed. Installation completed successfully.

To remove SQT

Run @sqdrop.sql