키워드 분류

기본

1. 객체
   1-1. Table, Index(B tree, bitmap), View, Material View
   1-2. Procedure, Function, Trigger, Sequence, Synonym
   1-3. SCN
2. Statement: DML, DDL, TCL, DCL
3. row type
   3-1. primitives: NUMBER, VARCHAR2, NVARCHAR2, ...
   3-2. LOB: CLOB, NCLOB, BLOB
4. Data Dictionary, DB 기본 View
   4-1. ALL_TABLES, ALL_USERS, DBA_TABLES, DBA_SEGMENTS, USER_CONSTRAINTS, ...
   4-2. V$SESSION, GV$SESSION, V$SQL_PLAN, ...
5. DD(System Tables): 4번 DD View의 code를 조회하면 실제 테이블 이름이 나온다. tibero는 SYS._DD_TBL과 같은 이름이다.
6. LOB segment

physical structure(file, disk)

1. Database instance - Tablespace - Segment - Extent - Datablock - OS block
2. Datafile / Controlfile
3. Row Chaining, Row Migration, Chained Row Pieces
4. Redo Log
5. Undo Tablespace, ITL

logical structure(memory)

1. SGA / PGA
2. Buffer Cache, Large Pool
3. Redo Log Buffer, undo retention

Lock

1. transaction(tx) isolation level
   1-1. read uncommitted, read committed, repeatable read, serializable
   1-2. dirty read, non-repeatable read, phantom read
2. DML lock, DDL lock (row lock, table lock // RS, RX, S, SRX, X)
3. ACID property

SQL PLAN

1. parser, optimizer
   1-1. hard parsing, soft parsing
   1-2. SQL hint
2. join
   2-1. Nested Loop(NL) join
   2-2. sort merge join
   2-3. hash join
3. scan
   3-1. index unique scan, index range scan, index fast full scan, ...

동작 방식

1. DB instance 상태 (SHUTDOWN, NOMOUNT, MOUNT, OPEN)
2. DB instance 종료 (NORMAL, TRANSACTIONAL, IMMEDIATE, ABORT)
3. high water mark(HWM)
4. SCN 증가 원인
5. Oracle RAC의 간단한 구성 원리와 제공하는 기능

recovery

1. instance recovery, media recovery
2. roll forward, roll back
3. incarnation number