기술지식

제품명 Tibero 등록일 2019.01.22
문서형식 TNote 서비스유형 튜닝 및 모니터링>튜닝
제목 티베로 운영 가이드(초심자용)

티베로를 처음 접하는 초심자용 티베로 운영 가이드입니다.

 

Table of Contents  

 

1. Overview

2. Tibero Configuration

  2.1 Environment

  2.2 Tibero Initialization Parameter

  2.3 System files

  2.4 Tibero Instance Logs

3. Tibero Client Connection

  3.1 tbsql

  3.2 tbdsn.tbr

4. Tibero Process Startup & Shutdown

  4.1 Single

  4.2 TAC

    4.2.1 without TAS

    4.2.2 Using TAS

  4.3 SSVR+TAS+TAC

  4.4 TSC

  4.5 Startup Error

5. Tibero Monitoring

  5.1 Instance/Database Info

  5.2 Memory Info

    5.2.1 Tibero Memory Info

    5.2.2 Buffer Hit Ratio

    5.2.3 Shared Cache Hit Ratio

  5.3 Tablespace Usage Info

  5.4 Object Info

    5.4.1 Total Object

    5.4.2 Invalid Object

  5.5 Session Info

    5.5.1 Sql Information

    5.5.2 Current Session

  5.6 Lock Info

    5.6.1 Current Lock Info

    5.6.2 Hierarchical Lock Info(TAC)

  5.7 Top SQL Info

    5.7.1 Top 10 SQL Ordered by Elapsed Time

    5.7.2 Top 10 SQL Ordered by gets

    5.7.3 Top 10 SQL Ordered by Elap/Exec(ms)

  5.8 Cluster Manager Info (Using TAC)

  5.9 Active Storage Info (Using TAC)

6. Performance Analysis

  6.1 TPR Report

  6.2 SQL Plan

  6.3 tbprof

7. Trouble Shooting

  7.1 Error Check

    7.1.1 TBR-<number> Error Code

    7.1.2 BUG - Internal Error

  7.2 Log Collection

 

 

첨부파일
Plugin HTML5