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

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