|
1 8000 8000 8000 8000 8000 8000 8000 8000
8 rows selected.
--//这样更改才生效.
SYS@book> alter system reset "_spin_count";
System altered.
--//实际上可以但是设置_latch_class_N参数.
SYS@book> alter system set "_latch_class_0"=1000 scope=spfile;
System altered.
--//重启数据库观察:
SYS@book> select * from x$ksllclass ;
ADDR INDX INST_ID SPIN YIELD WAITTIME SLEEP0 SLEEP1 SLEEP2 SLEEP3 SLEEP4 SLEEP5 SLEEP6 SLEEP7
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
00000000861986C0 0 1 1000 0 1 8000 8000 8000 8000 8000 8000 8000 8000
00000000861986EC 1 1 20000 0 1 1000 1000 1000 1000 1000 1000 1000 1000
0000000086198718 2 1 20000 0 1 8000 8000 8000 8000 8000 8000 8000 |