数据字典
数据库版本
SQL> select BANNER_FULL from v$version; BANNER_FULL -------------------------------------------------------------------------------- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0
x$kvit记录了ORACLE使用的cpu数量，后台进程扫描lru列触发增量检查点比例等详细信息:
X$KVIT -- [K]ernel Layer Performance Layer [V] [I]nformation tables [T]ransitory Instance parameters
SQL> select * from x$kvit; ADDR INDX INST_ID CON_ID KVITVAL KVITTAG KVITDSC ---------------- ---------- ---------- ---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- 00000000149FBE20 0 1 0 4 ksbcpurawthrcnt number of raw CPU threads in the system used by Oracle 00000000149FBE30 1 1 0 4 ksbcpueffthrcnt number of effective CPU threads in the system used by Oracle 00000000149FBE40 2 1 0 4 ksbcpucore number of physical CPU cores in the system used by Oracle 00000000149FBE50 3 1 0 4 ksbcpusocket number of physical CPU sockets in the system used by Oracle 00000000149FBE60 4 1 0 4 ksbcpu_hwm high water mark of number of CPUs used by Oracle 00000000149FBE70 5 1 0 4 ksbcpucore_hwm high water mark of number of CPU cores on system 00000000149FBE80 6 1 0 4 ksbcpusocket_hwm high water mark of number of CPU sockets on system 00000000149FBE90 7 1 0 4 ksbcpu_actual number of available CPUs in the system 00000000149FBEA0 8 1 0 1 ksbcpu_dr CPU dynamic reconfiguration supported 00000000149FBEB0 9 1 0 115522 kcbncbh number of buffers in cdb 00000000149FBEC0 10 1 0 115522 kcbnbh number of buffers 00000000149FBED0 11 1 0 25 kcbldq large dirty queue if kcbclw reaches this 00000000149FBEE0 12 1 0 40 kcbfsp Max percentage of LRU list foreground can scan for free 00000000149FBEF0 13 1 0 2 kcbcln Initial percentage of LRU list to keep clean 00000000149FBF00 14 1 0 5000 kcbnbf number buffer objects 00000000149FBF10 15 1 0 0 kcbwst Flag that indicates recovery or db suspension 00000000149FBF20 16 1 0 0 kcteln Error Log Number for thread open 00000000149FBF30 17 1 0 0 kcvgcw SGA: opcode for checkpoint cross-instance call 00000000149FBF40 18 1 0 0 kcvgcw SGA:opcode for pq checkpoint cross-instance call 19 rows selected.