Overview

This document describes the method to recreate TPR when it is occasionally necessary during service operation.

Method

1. Recreate Tibero 7 TPR (Tibero Performance Repository)

Recreate the tables and directories related to TPR.

Check the automatic collection parameter and activate it if it is turned off.

1. Recreate TPR related tables
SQL> @$TB_HOME/scripts/tpr_drop.sql
SQL> @$TB_HOME/scripts/tpr.sql

2. Manually create TPR related directories
SQL> create directory tpr_report_dir as '@SVR_REPORT_DIR@';
SQL> create directory tpr_tip_dir as '@SVR_HOME@/config';

3. Compile Invalid Objects
SQL> alter PACKAGE SYS.DBMS_SQLTUNE compile;
SQL> alter PACKAGE SYS.DBMS_TPR compile;
SQL> alter PACKAGE SYS.DBMS_XPLAN compile;

4. Check TIBERO_PERFORMANCE_REPOSITORY parameter
SQL> show parameter performance
NAME                           TYPE     VALUE
----------------------------- -------- ----------------------------------------
TIBERO_PERFORMANCE_REPOSITORY  Y_N      NO

5. Change and verify TIBERO_PERFORMANCE_REPOSITORY parameter (apply .tip file)
SQL> alter system set TIBERO_PERFORMANCE_REPOSITORY=Y;
System altered.
SQL> show parameter performance
NAME                           TYPE     VALUE
----------------------------- -------- ----------------------------------------
TIBERO_PERFORMANCE_REPOSITORY  Y_N      YES