[ORACLE]数据字典 x$kvit

数据字典

数据库版本

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.

 

posted on 2020-05-05 13:14  InnoLeo  阅读(248)  评论(0编辑  收藏  举报