Index

Symbols

$PATH, Installation Environment

$TB_HOME, Installation Environment

$TB_SID, Installation Environment

$TB_SID.tip, Control Files

$TB_SID.tip parameters

LOG_REPLICATION_DEST_N, Primary Settings and Operations
LOG_REPLICATION_MODE, Primary Settings and Operations
LOG_REPLICATION_N_ENABLE, Primary Settings and Operations

A

ACCT, Processes

additional privileges, Additional Privileges

agent process, Background Process

AGNT, Background Process

ALL_COL_PRIVS view, Viewing Privilege Data

ALL_COL_PRIVS_MADE view, Viewing Privilege Data

ALL_COL_PRIVS_RECD view, Viewing Privilege Data

ALL_CONS_COLUMNS view, Viewing Constraint Data

ALL_CONSTRAINTS view, Viewing Constraint Data

ALL_DB_LINKS view, Viewing DBLink Data

ALL_IDX_COLUMNS view, Viewing Index Data

ALL_INDEXES view, Viewing Index Data

ALL_PART_INDEXES view, Viewing Partition Data

ALL_PART_TABLES view, Viewing Partition Data

ALL_SEQUENCES view, Viewing Sequence Data

ALL_SYNONYMS view, Viewing Synonym Data

ALL_TABLES view, Viewing Table Data

ALL_TBL_COLUMNS view, Viewing Table Data

ALL_TBL_PRIVS view, Viewing Privilege Data

ALL_UPDATABLE_COLUMNS view, Viewing View Data

ALL_USERS view, Viewing User Data

ALL_VIEWS view, Viewing View Data

ALTER ANY SEQUENCE statement, Creating, Changing, and Deleting Sequences

ALTER DATABASE, Changing Tablespaces

ALTER DATABASE statement, Creating and Deleting Log Files

DROP LOGFILE clause, Creating and Deleting Log Files

ALTER SEQUENCE statement, Creating, Changing, and Deleting Sequences

ALTER TABLE statement, Creating, Altering, and Dropping Tables

ALTER TABLESPACE statement, Changing an Encrypted Tablespace

ALTER USER, Creating, Modifying, and Removing Users

application developers, Application Developers

ARCH ASYNC, Log Transmission Methods

archive log saving and multiplexing, Redo Log File Structure

Archive log setting, Redo Log File Structure

archived log file, Backups

ARCHIVELOG, Log Files, Redo Log File Structure

ARCHIVELOG mode, Log Files, Backup Types

archiving, Log Files

audit trails, Audit Trails

audit trails views, Audit Trails

DBA_AUDIT_TRAIL, Audit Trails
USER_AUDIT_TRAIL, Audit Trails

auditing, Auditing

auditing SYS User, Auditing SYS User

automatic recovery, Basic Functions

AVAILABILITY mode, Primary Settings and Operations

B

background process, Background Process

background processes

AGNT, Background Process
DBWR, Background Process
MGWP, Background Process
MONP, Background Process

backup, Backups

backup and recovery examples, Backup and Recovery Examples

binary TIP, Using Binary TIP

block, Tablespace Structures

boot mode

MOUNT, Recovery for Each Boot Mode
NOMOUNT, Recovery for Each Boot Mode
OPEN, Recovery for Each Boot Mode

boot modes, tbboot

MOUNT, tbboot
NOMOUNT, tbboot
NORMAL, tbboot
RESETLOGS, tbboot

BTIP, Using Binary TIP

C

CATH, Processes

CCC, Components

CLGC, Processes

client environment variables

TB_DSN_FILE, Client Environment Variables
TB_NLS_DATE_FORMAT, Client Environment Variables
TB_NLS_LANG, Client Environment Variables
TB_NLS_NCHAR, Client Environment Variables
TB_NLS_TIMESTAMP_FORMAT, Client Environment Variables
TBCLI_LOG_LVL, Client Environment Variables
TBXA_LOG_LVL, Client Environment Variables

Cluster Resource ROOT mode, Cluster Resource ROOT Mode

CMPT, Processes

cmrctl add commands

cmrctl add as, cmrctl add
cmrctl add cluster, cmrctl add
cmrctl add db, cmrctl add
cmrctl add network, cmrctl add
cmrctl add service, cmrctl add
cmrctl add vip, cmrctl add

cmrctl command, cmrctl

cmrctl commands

cmrctl act, cmrctl act
cmrctl add, cmrctl add
cmrctl deact, cmrctl deact
cmrctl del (delete), cmrctl del (delete)
cmrctl modify, cmrctl modify
cmrctl show, cmrctl show
cmrctl start, cmrctl start
cmrctl stop, cmrctl stop
remote CM control, Remote CM control via cmrctl

cold backup, Backup Types

column, Tables

column encryption, Encrypting a Column

commit, Two-phase Commit Mechanism

commit phase, Two-phase Commit Mechanism

commit point sites, In-Doubt Transaction Processing of DBLink

communication encryption, Communication Encryption

complete recovery, Media Recovery

composite partition creation, Creating Composite Partitions

concatenated index, Indexes

consistent backup, Backup Types

constraint data, Viewing Constraint Data

constraint data views, Viewing Constraint Data

ALL_CONS_COLUMNS, Viewing Constraint Data
ALL_CONSTRAINTS, Viewing Constraint Data
DBA_CONS_COLUMNS, Viewing Constraint Data
DBA_CONSTRAINTS, Viewing Constraint Data
USER_CONS_COLUMNS, Viewing Constraint Data
USER_CONSTRAINTS, Viewing Constraint Data

constraint states, Constraint States

constraints, Constraints

consumer slave, Parallel Queries

control File, Directory Structure

control file data views, Viewing Control File Data

V$CONTROLFILE, Viewing Control File Data
V$DATABASE, Viewing Control File Data

control files, Control Files

control thread, Worker Process

Crash Recovery

Average Crash Recovery Time Setting, Crash Recovery

crash recovery, Crash Recovery

CRCF, Processes

CREATE ANY SEQUENCE statement, Creating, Changing, and Deleting Sequences

CREATE ANY SYNONYM statement, Creating and Deleting Synonyms

CREATE ANY TRIGGER statement, Creating and Deleting Triggers

CREATE ANY VIEW statement, Creating, Changing, and Deleting Views

CREATE OR REPLACE VIEW statement, Creating, Changing, and Deleting Views

CREATE PUBLIC SYNONYM statement, Creating and Deleting Public Synonyms

CREATE SEQUENCE statement, Creating, Changing, and Deleting Sequences

CREATE SYNONYM statement, Creating and Deleting Synonyms

CREATE TABLE statement, Creating Users and Tables, Creating, Altering, and Dropping Tables, Creating Partitions

CREATE TABLESPACE, Creating and Deleting Tablespaces

CREATE TABLESPACE statement, Creating an Encrypted Tablespace

CREATE TRIGGER statement, Creating and Deleting Triggers

CREATE USER, Creating, Modifying, and Removing Users, Creating an OS Authenticated User

CREATE USER statement, Creating Users and Tables

CREATE VIEW statement, Creating, Changing, and Deleting Views

crfconf command, crfconf

CWS, Components

D

data encryption, Data Encryption

data encryption configuration, Configuring an Environment

data File, Directory Structure

data replication, Key Features

database administrator, DBA

database cluster, Key Features

database file

control file, Component Files in Tibero
data file, Component Files in Tibero
log file, Component Files in Tibero
temp file, Component Files in Tibero

database link, Database Links (DBLinks)

database link data views, Viewing DBLink Data

ALL_DB_LINKS, Viewing DBLink Data
DBA_DB_LINKS, Viewing DBLink Data
USER_DB_LINKS, Viewing DBLink Data

database security, User Management and Database Security

database users, Database Users

database write process, Background Process

DBA, DBA

DBA's checkpoints, DBA

DBA_2PC_PENDING view, DBA_2PC_PENDING View

DBA_AUDIT_TRAIL view, Audit Trails

DBA_COL_PRIVS view, Viewing Privilege Data

DBA_CONS_COLUMNS view, Viewing Constraint Data

DBA_CONSTRAINTS view, Viewing Constraint Data

DBA_DB_LINKS view, Viewing DBLink Data

DBA_IDX_COLUMNS view, Viewing Index Data

DBA_INDEXES view, Viewing Index Data

DBA_PART_INDEXES view, Viewing Partition Data

DBA_PART_TABLES view, Viewing Partition Data

DBA_ROLE_PRIVS view, Viewing Role Data

DBA_ROLES view, Viewing Role Data

DBA_SEQUENCES view, Viewing Sequence Data

DBA_SYNONYMS view, Viewing Synonym Data

DBA_SYS_PRIVS view, Viewing Privilege Data

DBA_TABLES view, Viewing Table Data

DBA_TABLESPACES view, Viewing Tablespace Data, Viewing Encrypted Tablespace Data

DBA_TBL_COLUMNS view, Viewing Table Data

DBA_TBL_PRIVS view, Viewing Privilege Data

DBA_UPDATABLE_COLUMNS view, Viewing View Data

DBA_USERS view, Viewing User Data

DBA_VIEWS view, Viewing View Data

DBMS log file (dlog), Directory Structure

DBWR, Background Process

default role, Default Roles

default roles, Default Roles

degree of parallelism (DOP), Degree of Parallelism

delete backup set, Basic Functions

DIAG, Processes

disk block, Schema Object Management

disk blocks, Disk Blocks

distributed database link, Key Features

distributed transaction, Distributed Transactions

distribution method for TPS

broadcast, Distributing a TPS
hash, Distributing a TPS
range, Distributing a TPS
round-robin, Distributing a TPS
send idxm, Distributing a TPS

down modes, tbdown

ABNORMAL, tbdown
ABORT, tbdown
IMMEDIATE, tbdown
NORMAL, tbdown
POST_TX, tbdown
SWITCHOVER, tbdown

DROP ANY SEQUENCE statement, Creating, Changing, and Deleting Sequences

DROP ANY SYNONYM statement, Creating and Deleting Synonyms

DROP ANY VIEW statement, Creating, Changing, and Deleting Views

DROP PUBLIC SYNONYM statement, Creating and Deleting Public Synonyms

DROP SEQUENCE statement, Creating, Changing, and Deleting Sequences

DROP SYNONYM statement, Creating and Deleting Synonyms

DROP TABLE statement, Creating, Altering, and Dropping Tables

DROP TABLESPACE, Creating and Deleting Tablespaces

DROP TRIGGER statement, Creating and Deleting Triggers

DROP VIEW statement, Creating, Changing, and Deleting Views

dump files, Directory Structure

E

encrypted tablespace data views, Viewing Encrypted Tablespace Data

DBA_TABLESPACES view, Viewing Encrypted Tablespace Data
V$ENCRYPTED_TABLESPACES view, Viewing Encrypted Tablespace Data

encryption algorithm, Overview

environment variables, Installation Environment

extent, Tablespace Structures

F

file descriptor, Listener
first phase, Two-phase Commit Mechanism
foreground process, Worker Process

G

GCA, Components
global consistency, Global Consistency
granule, Parallel Queries
GWA, Components

H

High Availability (HA) configuration, High Availability (HA) Configuration
hot backup, Backup Types

I

in-doubt transaction, In-Doubt Transaction Processing of XA

INC, Components

incomplete recovery, Media Recovery

inconsistent backup, Backup Types

inconsistent backup process, Performing a Backup

incremental backup, Basic Functions

index data, Viewing Index Data

index data views, Viewing Index Data

ALL_IDX_COLUMNS, Viewing Index Data
ALL_INDEXES, Viewing Index Data
DBA_IDX_COLUMNS, Viewing Index Data
DBA_INDEXES, Viewing Index Data
USER_IDX_COLUMNS, Viewing Index Data
USER_INDEXES, Viewing Index Data

INDEX ORGANIZED TABLE, INDEX ORGANIZED TABLE

index partition creation, Creating Index Partitions

indexes, Indexes

INITRANS, INITRANS Parameter

INITRANS parameter, INITRANS Parameter

internal log file (ilog), Directory Structure

L

LGWR ASYNC, Log Transmission Methods

LGWR SYNC, Log Transmission Methods

Listener, Listener

listener, Listener

listener log file (lsnr), Directory Structure

LNR, Processes

LNW, Processes

Log file, Log Files

log File, Directory Structure

log file

archived log file, Component Files in Tibero
online log file, Component Files in Tibero

log file creation, Creating and Deleting Log Files

log file data views, Viewing Log File Data

V$LOG, Viewing Log File Data
V$LOGFILE, Viewing Log File Data

log file deletion, Creating and Deleting Log Files

log group multiplexing, Redo Log File Structure

log member, Redo Log File Structure

log member multiplexing, Redo Log File Structure

log members, Redo Log File Structure

log record, Log Files

log switch, Log Files

logical backup, Backups

LS command, tbSQL Utility Usage

LSNR_DENIED_IP parameter, IP-based Network Access Control

LSNR_DENIED_IP_FILE parameter, IP-based Network Access Control

LSNR_INVITED_IP parameter, IP-based Network Access Control

LSNR_INVITED_IP_FILE parameter, IP-based Network Access Control

M

media recovery, Media Recovery
MGWP, Background Process
monitor process, Background Process
MONP, Background Process
MOUNT, Performing a Backup
MTC, Components
multiplexing, Log Files

N

network access control, Network Access Control

full network access control, Full Network Access Control
IP-based network access control, IP-based Network Access Control

NMGR, Processes

NMS, Components

NOARCHIVELOG, Log Files

NOARCHIVELOG mode, Log Files, Backup Types

NOAUDIT command, Enabling and Disabling Auditing

non-system tablespace, Creating and Deleting Tablespaces

non-unique index, Indexes, Efficient Index Management

notes for defining a partition, Creating Partitions

O

offline backup, Backup Types
online backup, Backup Types
online full backup, Basic Functions
online log files, Backups
online media recovery, Online Media Recovery
OPEN, Performing a Backup
operation, Degree of Parallelism

P

parallel execution (PE), Overview

parallel query processing, Key Features

parallel views, Views for Parallel Execution Performance Analysis

partition data, Viewing Partition Data

partition data views, Viewing Partition Data

ALL_PART_INDEXES, Viewing Partition Data
ALL_PART_TABLES, Viewing Partition Data
DBA_PART_INDEXES, Viewing Partition Data
DBA_PART_TABLES, Viewing Partition Data
USER_PART_INDEXES, Viewing Partition Data
USER_PART_TABLES, Viewing Partition Data

partitions, Partitions

HASH, Partitions
LIST, Partitions
RANGE, Partitions

PCTFREE parameter, PCTFREE Parameter

PE types

inter-operation PE, Degree of Parallelism
intra-operation PE, Degree of Parallelism

PE_SLAVE, Degree of Parallelism

PE_SLAVE set, 2-Set Structure

Consumer set, 2-Set Structure
Producer set, 2-Set Structure

PERFORMANCE mode, Primary Settings and Operations

PES, Parallel Queries

physical backup, Backups

prepare phase, Two-phase Commit Mechanism

primary DB, Overview

Primary operation mode

AVAILABILITY, Primary Settings and Operations
PERFORMANCE, Primary Settings and Operations
PROTECTION, Primary Settings and Operations

primary operation mode, Primary Settings and Operations

private DBLink, Creating and Removing DBLinks

privilege

schema object privilege, Schema Object Privileges
system privilege, System Privileges
WITH GRANT OPTION, Schema Object Privileges

privilege data, Viewing Privilege Data

privilege data views, Viewing Privilege Data

ALL_COL_PRIVS, Viewing Privilege Data
ALL_COL_PRIVS_MADE, Viewing Privilege Data
ALL_COL_PRIVS_RECD, Viewing Privilege Data
ALL_TBL_PRIVS, Viewing Privilege Data
DBA_COL_PRIVS, Viewing Privilege Data
DBA_SYS_PRIVS, Viewing Privilege Data
DBA_TBL_PRIVS, Viewing Privilege Data
USER_COL_PRIVS, Viewing Privilege Data
USER_COL_PRIVS_MADE, Viewing Privilege Data
USER_COL_PRIVS_RECD, Viewing Privilege Data
USER_SYS_PRIVS, Viewing Privilege Data
USER_TBL_PRIVS, Viewing Privilege Data

privileges, Privileges

producer slave, Parallel Queries

profiles, Profiles

PROTECTION mode, Primary Settings and Operations

public DBLink, Creating and Removing DBLinks

public synonyms, Creating and Deleting Public Synonyms

PUBLICSYN view, Viewing Synonym Data

Q

QC

order, Parallel Queries
random, Parallel Queries

query coordinator (QC), Degree of Parallelism

query optimizer, Key Features

R

recovery, Recovery

recovery manager, Recovery Manager (RMGR)

redo log, Log Files

Redo logs, Log Files

replication server, Configuring a Replication Server

role, Roles

CONNECT, Predefined Roles
DBA, Predefined Roles
HS_ADMIN_ROLE, Predefined Roles
RESOURCE, Predefined Roles

role data, Viewing Role Data

role data views, Viewing Role Data

DBA_ROLE_PRIVS, Viewing Role Data
DBA_ROLES, Viewing Role Data
ROLE_ROLE_PRIVS, Viewing Role Data
ROLE_SYS_PRIVS, Viewing Role Data
ROLE_TAB_PRIVS, Viewing Role Data
USER_ROLE_PRIVS, Viewing Role Data

ROLE_ROLE_PRIVS view, Viewing Role Data, Security Administrator

ROLE_SYS_PRIVS view, Viewing Role Data, Security Administrator

ROLE_TAB_PRIVS view, Viewing Role Data, Security Administrator

roles, Roles

rollback, Two-phase Commit Mechanism

row, Tables

row level locking, Row Level Locking

S

schema, Managing User Accounts

schema object, Schema Object Management

Schema Object Privilege

TRUNCATE, Schema Object Privileges

schema object privilege, Schema Object Privileges

ALTER, Schema Object Privileges
DELETE, Schema Object Privileges
INDEX, Schema Object Privileges
INSERT, Schema Object Privileges
REFERENCES, Schema Object Privileges
SELECT, Schema Object Privileges
TRUNCATE, Schema Object Privileges
UPDATE, Schema Object Privileges

second Phase, Two-phase Commit Mechanism

security administrator (SYSSEC), Security Administrator

security data views

ROLE_ROLE_PRIVS, Security Administrator
ROLE_SYS_PRIVS, Security Administrator
ROLE_TAB_PRIVS, Security Administrator

segment, Tablespace Structures, Overview

Separation of Duties (SOD), Overview

sequence data, Viewing Sequence Data

sequence data views, Viewing Sequence Data

ALL_SEQUENCES, Viewing Sequence Data
DBA_SEQUENCES, Viewing Sequence Data
USER_SEQUENCES, Viewing Sequence Data

sequence number, Media Recovery

sequences, Sequences

SID, tbdsn.tbr Structure

SID detailed information, tbdsn.tbr Structure

single index, Indexes

SMR, Processes

SOD administrators

security administrator (SYSSEC), Security Administrator
system administrator (SYSADM), System Administrator
system auditor (SYSAUD), System Auditor

SQL Standard

SQL-99, tbSQL Utility Usage

SQL standard, tbSQL Utility Usage

SQL-92, tbSQL Utility Usage

standby DB, Overview

synonym data, Viewing Synonym Data

synonym data views, Viewing Synonym Data

ALL_SYNONYMS, Viewing Synonym Data
DBA_SYNONYMS, Viewing Synonym Data
PUBLICSYN, Viewing Synonym Data
USER_SYNONYMS, Viewing Synonym Data

synonyms, Synonyms

SYS, SYS

sysadmin, System Administrators

system administrator, System Administrators

system administrator (SYSADM), System Administrator

system auditor (SYSAUD), System Auditor

system log file (slog), Directory Structure

system privilege, System Privileges

ALTER ANY INDEX, System Privileges
ALTER ANY MATERIALIZED VIEW, System Privileges
ALTER ANY PROCEDURE, System Privileges
ALTER ANY ROLE, System Privileges
ALTER ANY SEQUENCE, System Privileges
ALTER ANY TABLE, System Privileges
ALTER ANY TRIGGER, System Privileges
ALTER DATABASE, System Privileges
ALTER SYSTEM, System Privileges
ALTER TABLESPACE, System Privileges
ALTER USER, System Privileges
COMMENT ANY TABLE, System Privileges
CREATE ANY INDEX, System Privileges
CREATE ANY MATERIALIZED VIEW, System Privileges
CREATE ANY PROCEDURE, System Privileges
CREATE ANY SEQUENCE, System Privileges
CREATE ANY SYNONYM, System Privileges
CREATE ANY TABLE, System Privileges
CREATE ANY TRIGGER, System Privileges
CREATE ANY VIEW, System Privileges
CREATE MATERIALIZED VIEW, System Privileges
CREATE PROCEDURE, System Privileges
CREATE PUBLIC SYNONYM, System Privileges
CREATE ROLE, System Privileges
CREATE SEQUENCE, System Privileges
CREATE SESSION, System Privileges
CREATE SYNONYM, System Privileges
CREATE TABLE, System Privileges
CREATE TABLESPACE, System Privileges
CREATE TRIGGER, System Privileges
CREATE USER, System Privileges
CREATE VIEW, System Privileges
DELETE ANY TABLE, System Privileges
DROP ANY INDEX, System Privileges
DROP ANY MATERIALIZED VIEW, System Privileges
DROP ANY PROCEDURE, System Privileges
DROP ANY ROLE, System Privileges
DROP ANY SEQUENCE, System Privileges
DROP ANY SYNONYM, System Privileges
DROP ANY TABLE, System Privileges
DROP ANY TRIGGER, System Privileges
DROP ANY VIEW, System Privileges
DROP PUBLIC SYNONYM, System Privileges
DROP TABLESPACE, System Privileges
DROP USER, System Privileges
EXECUTE ANY PROCEDURE, System Privileges
GRANT ANY OBJECT PRIVILEGE, System Privileges
GRANT ANY PRIVILEGE, System Privileges
GRANT ANY ROLE, System Privileges
INSERT ANY TABLE, System Privileges
REFRESH ANY CACHE GROUP, System Privileges
SELECT ANY DICTIONARY, System Privileges
SELECT ANY SEQUENCE, System Privileges
SELECT ANY TABLE, System Privileges
SYSDBA, System Privileges
TRUNCATE ANY TABLE, System Privileges
UPDATE ANY TABLE, System Privileges

system tablespace, Creating and Deleting Tablespaces

T

T-Up, Directory Structure

table compression, Compressing Tables

table data, Viewing Table Data

table data views, Viewing Table Data

ALL_TABLES, Viewing Table Data
ALL_TBL_COLUMNS, Viewing Table Data
DBA_TABLES, Viewing Table Data
DBA_TBL_COLUMNS, Viewing Table Data
USER_TABLES, Viewing Table Data
USER_TBL_COLUMNS, Viewing Table Data

tables, Tables

tablespace data views, Viewing Tablespace Data

DBA_TABLESPACES, Viewing Tablespace Data
USER_TABLESPACES, Viewing Tablespace Data
V$TABLESPACE, Viewing Tablespace Data

tablespace encryption, Encrypting a Tablespace

tablespace recovery, Basic Functions

tablespaces, Tablespaces

TAC, Overview

TAC configuration, TAC Configuration

TAC environment configuration, Configuring a TAC Environment

TAC processes, Processes

TAC structure, Components

TAS-TAC configuration, TAS-TAC Configuration

TB_DSN_FILE, Client Environment Variables

TB_HOME, Installation Environment

TB_NLS_DATE_FORMAT, Client Environment Variables

TB_NLS_LANG, Client Environment Variables

TB_NLS_NCHAR, Client Environment Variables

TB_NLS_TIMESTAMP_FORMAT, Client Environment Variables

TB_SID, Installation Environment

tbboot, Directory Structure

TBCLI_LOG_LVL, Client Environment Variables

tbdsn.tbr, tbdsn.tbr

tbExport, Directory Structure

tbImport, Directory Structure

tbLoader, Directory Structure

tbpc, Directory Structure

tbSQL, Directory Structure, tbSQL Utility Usage

tbSQL utility's commands, tbSQL Utility Usage

tbsvr, Directory Structure

TBXA_LOG_LVL, Client Environment Variables

thread, Worker Process

Tibero , About This Document, Overview

Tibero Active Cluster, Key Features, Tibero Active Cluster

Tibero Cluster Manager initialization parameters, Initialization Parameters

Tibero manager process, Background Process

Tibero RDBMS's process structure, Process Structure

Tibero Standby Cluster, Overview

Tibero standby cluster data views, Viewing Tibero Standby Cluster Data

V$STANDBY, Viewing Tibero Standby Cluster Data
V$STANDBY_DEST, Viewing Tibero Standby Cluster Data
V$STANDBY_LOG, Viewing Tibero Standby Cluster Data
V$STANDBY_LOGFILE, Viewing Tibero Standby Cluster Data

Tibero Standby Cluster log transmission method

ARCH ASYNC, Log Transmission Methods
LGWR ASYNC, Log Transmission Methods
LGWR SYNC, Log Transmission Methods

Tibero Standby Cluster's log transmission method, Log Transmission Methods

Tibero Standby Cluster's process, Processes

TmaxData, tbSQL Utility Usage

transaction entry list, INITRANS Parameter

transaction manager, XA

triggers, Triggers

two-phase commit mechanism, Two-phase Commit Mechanism

U

unique index, Indexes, Efficient Index Management

user data, Viewing User Data

user data views, Viewing User Data

ALL_USERS, Viewing User Data
DBA_USERS, Viewing User Data
USER_USERS, Viewing User Data

USER_AUDIT_TRAIL view, Audit Trails

USER_COL_PRIVS view, Viewing Privilege Data

USER_COL_PRIVS_MADE view, Viewing Privilege Data

USER_COL_PRIVS_RECD view, Viewing Privilege Data

USER_CONS_COLUMNS view, Viewing Constraint Data

USER_CONSTRAINTS view, Viewing Constraint Data

USER_DB_LINKS view, Viewing DBLink Data

USER_IDX_COLUMNS view, Viewing Index Data

USER_INDEXES view, Viewing Index Data

USER_PART_INDEXES view, Viewing Partition Data

USER_PART_TABLES view, Viewing Partition Data

USER_ROLE_PRIVS view, Viewing Role Data

USER_SEQUENCES view, Viewing Sequence Data

USER_SYNONYMS view, Viewing Synonym Data

USER_SYS_PRIVS view, Viewing Privilege Data

USER_TABLES view, Creating Users and Tables, Viewing Table Data

USER_TABLESPACES view, Viewing Tablespace Data

USER_TBL_COLUMNS view, Viewing Table Data

USER_TBL_PRIVS view, Viewing Privilege Data

USER_UPDATABLE_COLUMNS view, Viewing View Data

USER_USERS view, Viewing User Data

USER_VIEWS view, Viewing View Data

V

V$CONTROLFILE view, Viewing Control File Data

V$DATABASE view, Viewing Control File Data

V$ENCRYPTED_TABLESPACES view, Viewing Encrypted Tablespace Data

V$LOG view, Viewing Log File Data

V$LOGFILE view, Viewing Log File Data

V$SESSION, tbSQL Utility Usage

V$STANDBY view, Viewing Tibero Standby Cluster Data

V$STANDBY_DEST view, Viewing Tibero Standby Cluster Data

V$STANDBY_LOG view, Viewing Tibero Standby Cluster Data

V$STANDBY_LOGFILE view, Viewing Tibero Standby Cluster Data

V$SYSSTAT view, V$SYSSTAT

V$TABLESPACE view, Viewing Tablespace Data

VERIFY_FUNCTION, VERIFY_FUNCTION

view data, Viewing View Data

view data views, Viewing View Data

ALL_UPDATABLE_COLUMNS, Viewing View Data
ALL_VIEWS, Viewing View Data
DBA_UPDATABLE_COLUMNS, Viewing View Data
DBA_VIEWS, Viewing View Data
USER_UPDATABLE_COLUMNS, Viewing View Data
USER_VIEWS, Viewing View Data

views, Views

W

WATH, Processes
WITH GRANT OPTION, Schema Object Privileges
WLGC, Processes
worker process, Worker Process
worker thread, Worker Process
WRCF, Processes

X

XA, XA
XA transaction branch, DBA_2PC_PENDING View
XID, XA

Index
Prev

Prev
Appendix D. Client Environment Variables	Home