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.
NoteBased 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.