Skip to main content

Search

Welcome to Tibero GTS!

How to Backup and Extract TPR Report for Dates Exceeding TPR Snapshot Retention Period

Document Type | Technical Information

Category | Administration

Applicable Product Version | 6FS07

Document Number | TADTI032

 

Overview

Because TM (Tibero Monitor) does not support backing up or extracting reports for dates that exceed the TPR (Tibero Performance Repository) Snapshot retention period, it is difficult to output that data.
Therefore, you can work around this by backing up the tables used by the TPR package, restoring the data, and then extracting the report.
 
 

Method

The tables used by the TPR package are as follows.
Note
Based on Tibero6 FS07 version.
  • _TPR_ACTIVE_SESSION_HISTORY
  • _TPR_BASELINE
  • _TPR_FILESTAT
  • _TPR_JCNTSTAT
  • _TPR_LATCH
  • _TPR_LIBRARYCACHE
  • _TPR_LOG
  • _TPR_LOGFILE
  • _TPR_METRIC
  • _TPR_MISC
  • _TPR_MISC_STR
  • _TPR_MODIFIED_PARAM
  • _TPR_OSSTAT2
  • _TPR_PGASTAT
  • _TPR_PROCESS
  • _TPR_SEGMENTSTAT
  • _TPR_SESSION
  • _TPR_SGASTAT
  • _TPR_SNAPSHOT
  • _TPR_SQLSTATS
  • _TPR_SQLTEXT
  • _TPR_SQLWA_HIST
  • _TPR_SQL_BIND_CAPTURE_ALL
  • _TPR_SQL_PLAN
  • _TPR_SQL_PLAN_STAT
  • _TPR_SSVR_JCNTSTAT
  • _TPR_SYSTEM_EVENT
  • _TPR_TEMPSEG_OP_USAGE
  • _TPR_UNDOSTAT
  • _TPR_WAITER_SESSION
  • _TPR_WAITSTAT
     
Also, you can query the list of _TPR related tables using the following query.
select table_name from all_tables where owner='SYS' and table_name like '%_TPR%' and table_name not like '%SAVE%';
Include all tables returned by the above query in the backup target and perform the backup using tbexport.
Afterward, import the tbexported data into all _TPR related tables using tbimport, and extract the report based on that data.
 
 
 

Related to