内部视图x$kvii
554078 kslerb event range base
873 kslnbe # of base events
285 kslnbesess # of base events in session
382 kslltl number of latches
2 ksbcpu_static initial number of CPUs in the system
4096 kcbswc DBWR max outstanding writes
1 kcbnwp number of DBWR processes
204 kcbscw DBWR write chunk
1 kctsat true if Statically Allocated Thread
1 kctthr THRead mounted by this instance – zero if none
1 ktsinm sga shadow value of instance_number
0 rfragns Global request id for site
其中kslltl为Oracle中父闩的数量,即kslltl=select count(*) from v$latch;
ksbcpu_static记录了当前cpu的内核总数。
kcbswc为Oracle单位时间内所能写出的最大块数(Largest # blocks you can write at any given time)实际受限于物理写出能力。
kctthr为当前实例的线程号。
关于这些视图的研究仍有诸多不明确。
附Oracle kernel 层次:
OPI | Oracle Program Interface |
KK | Compilation Layer – Parse SQL, compile PL/SQL |
KX | Execution Layer – Bind and execute SQL and PL/SQL |
K2 | Distributed Execution Layer – 2PC handling |
NPI | Network Program Interface |
KZ | Security Layer – Validate privs |
KQ | Query Layer |
RPI | Recursive Program Interface |
KA | Access Layer |
KD | Data Layer |
KT | Transaction Layer |
KC | Cache Layer |
KS | Services Layer |
KJ | Lock Manager Layer |
KG | Generic Layer |
KV | Kernel Variables (eg. x$KVIS and X$KVII) |
S or ODS | Operating System Dependencies |
Leave a Reply