Oracle的X$表系列介绍之-X$KSLLCLASS

SQL> select latch#,name from v$latchname where name='cache buffers chains';
    LATCH# NAME
---------- ----------------------------------------------------------------
        98 cache buffers chains
SQL> alter system set "_latch_class_1"=10000 scope=spfile;
System altered.
SQL> alter system set "_latch_classes"="98:1" scope=spfile;
System altered.
SQL> startup force;
ORACLE instance started.
Total System Global Area   80811208 bytes
Fixed Size                   451784 bytes
Variable Size              37748736 bytes
Database Buffers           41943040 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.
SQL> show parameter latch
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_latch_class_1                       string      10000
_latch_classes                       string      98:1
SQL> select indx, spin, yield, waittime from   x$ksllclass;
      INDX       SPIN      YIELD   WAITTIME
---------- ---------- ---------- ----------
         0      20000          0          1
         1      10000          0          1
         2      20000          0          1
         3      20000          0          1
         4      20000          0          1
         5      20000          0          1
         6      20000          0          1
         7      20000          0          1
8 rows selected.
SQL> 

--------------------next---------------------