X$ Fixed 테이블 약어

X$ Fixed 테이블의 일부는 오라클 데이터베이스 커널과 관련된 약어를 명칭의 접두어로 사용한다.

K로 시작하는 테이블이 커널과 관련된 Fixed 테이블이다.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

SELECT   DISTINCT          SUBSTR (name, 3,2) AS name     FROM v$fixed_table    WHERE name LIKE 'X$K%' ORDER BY 1;   NAME ---- K2 KA ... KY KZ   25 행이 선택되었습니다.

오라클 데이터베이스 커널과 관련된 약어는 아래와 같다.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

K: Kernel   - K2: Kernel Distributed Execution - 2PC   - KA: Kernel Access   - KC: Kernel Cache       - KCB     : Kernel Cache Buffer       - KCBW    : Kernel Cache Buffer Wait       - KCC     : Kernel Cache Control file       - KCCB    : Kernel Cache Control file Backup       - KCCCF   : Kernel Cache Copy Flash recovery area       - KCCDC   : Kernel Cache Control file Data file Copy       - KCP     : Kernel Cache transPortable tablespace       - KCR     : Kernel Cache Redo       - KCT     : Kernel Cache insTance   - KD: Kernel Data   - KG: Kernel Generic       - KGL     : Kernel Generic Library cache       - KGLJ    : Kernel Generic Library cache Java   - KJ: Kernel management   - KK: Kernel compilation   - KQ: Kernel Query   - KS: Kernel Service       - KSB     : Kernel Service Background       - KSM     : Kernel Service Memory       - KSU     : Kernel Service User       - KSUSE   : Kernel Service User SEssion       - KSUSECON: Kernel Service User SEssion COnnection       - KSUSEH  : Kernel Service User SEssion History   - KT: Kernel Transaction       - KTU     : Kernel Transaction Undo   - KV: Kernel Variable   - KX: Kernel eXecution       - KXS     : Kernel eXecution Sql   - KZ: Kernel security

[참고]

- Norbert Debes. Secrets of the Oracle Database. Apress, 2009

- Steve Adams. Oracle8i Internal Services for Waits, Latches, Locks, and Memory. O'Reilly, 1999