[20190416]11g下那些latch是Exclusive的.txt
[20190416]11g下那些latch是exclusive的.txt
--//昨天测试了11g下那些latch是共享的,链接:
--//是否反过来剩下的都是exclusive的.继续测试:
1.环境:
sys@book> @ ver1
port_string version banner
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/linux 2.4.xx 11.2.0.4.0 oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit production
2.建立测试脚本:
--//drop table exclusive_latches purge;
create table exclusive_latches(
version varchar2(50), /* oracle version */
latch# number, /* latch# */
name varchar2(200), /* ltach name */
shared varchar2(1) /* if 'n' then latch is exclusive */
);
--//建立表shared_latches.
spool list_exclusive_latches.sh
select 'sqlplus /nolog @is_latch_exclusive 0x'||addr||' '||latch#||' "'||translate(name,'''',' ')||'"'
from v$latch_parent;
spool off
--//获得latch list.仅仅测试latch parent就ok了.适当编辑整理脚本.
$ cat is_latch_exclusive.sql
connect / as sysdba
set verify off
whenever sqlerror exit;
set pagesize 0
alter session set max_dump_file_size=0;
oradebug setmypid
oradebug call kslgetl &1 1 2 3
oradebug call kslfre &1
insert into exclusive_latches(version,latch#,name,shared) select version,latch#,name,'n' from v$latch,v$instance where latch#=&2;
commit;
exit
3.执行:
$ . list_exclusive_latches.sh
--//略.
4.结果:
sys@book> select * from exclusive_latches;
version latch# name s
---------- ---------- -------------------------------------------------- -
11.2.0.4.0 0 pc and classifier lists for wlm n
11.2.0.4.0 1 post/wait queue n
11.2.0.4.0 2 hot latch diags n
11.2.0.4.0 3 test excl. non-parent l0 n
11.2.0.4.0 4 test excl. parent l0 n
11.2.0.4.0 5 test excl. parent2 l0 n
11.2.0.4.0 7 test excl. non-parent lmax n
11.2.0.4.0 8 process allocation n
11.2.0.4.0 9 call allocation n
11.2.0.4.0 10 interrupt manipulation n
11.2.0.4.0 11 session allocation n
11.2.0.4.0 12 session switching n
11.2.0.4.0 13 process group creation n
11.2.0.4.0 16 longop free list parent n
11.2.0.4.0 17 ksuosstats global area n
11.2.0.4.0 18 ksupkttest latch n
11.2.0.4.0 19 cached attr list n
11.2.0.4.0 20 ksim membership request latch n
11.2.0.4.0 22 object stats modification n
11.2.0.4.0 23 kss move lock n
11.2.0.4.0 25 ksbxic instance latch n
11.2.0.4.0 26 kse signature n
11.2.0.4.0 27 messages n
11.2.0.4.0 28 enqueues n
11.2.0.4.0 29 enqueue hash chains n
11.2.0.4.0 30 instance enqueue n
11.2.0.4.0 31 enqueue freelist latch n
11.2.0.4.0 32 trace latch n
11.2.0.4.0 33 fob s.o list latch n
11.2.0.4.0 34 fib s.o chain latch n
11.2.0.4.0 35 sga io buffer pool latch n
11.2.0.4.0 36 file io stats segmented array latch n
11.2.0.4.0 37 sga global fib table latch n
11.2.0.4.0 38 ksfq n
11.2.0.4.0 39 x$ksfqp n
11.2.0.4.0 40 i/o slave adaptor n
11.2.0.4.0 41 ksfv messages n
11.2.0.4.0 42 msg queue latch n
11.2.0.4.0 43 done queue latch n
11.2.0.4.0 44 session queue latch n
11.2.0.4.0 45 direct msg latch n
11.2.0.4.0 46 vecio buf des n
11.2.0.4.0 47 ksfv subheap n
11.2.0.4.0 48 resmgr:free threads list n
11.2.0.4.0 53 channel anchor n
11.2.0.4.0 54 dynamic channels n
11.2.0.4.0 55 ksv instance latch n
11.2.0.4.0 56 ksv class latch n
11.2.0.4.0 57 ksv msg queue latch n
11.2.0.4.0 58 ksv allocation latch n
11.2.0.4.0 59 ksv remote inst ops n
11.2.0.4.0 60 first spare latch - x non-parent n
11.2.0.4.0 61 second spare latch - x non-parent n
11.2.0.4.0 62 third spare latch - x non-parent n
11.2.0.4.0 63 fourth spare latch - x non-parent n
11.2.0.4.0 64 fifth spare latch - x non-parent n
11.2.0.4.0 65 sixth spare latch - x parent n
11.2.0.4.0 66 seventh spare latch - x parent n
11.2.0.4.0 67 eighth spare latch - x parent n
11.2.0.4.0 68 nineth spare latch - x parent n
11.2.0.4.0 69 tenth spare latch - x parent n
11.2.0.4.0 70 eleventh spare latch - children n
11.2.0.4.0 71 twelfth spare latch - children n
11.2.0.4.0 72 thirteenth spare latch - children n
11.2.0.4.0 73 fourteenth spare latch - children n
11.2.0.4.0 74 fifteenth spare latch - children n
11.2.0.4.0 85 ksxp shared latch n
11.2.0.4.0 86 ipc stats buffer allocation latch n
11.2.0.4.0 87 ipc other latch n
11.2.0.4.0 88 ksxp so latch n
11.2.0.4.0 89 segmented array pool n
11.2.0.4.0 90 granule operation n
11.2.0.4.0 91 ksxr large replies n
11.2.0.4.0 94 database property service latch n
11.2.0.4.0 95 os process allocation n
11.2.0.4.0 96 os process n
11.2.0.4.0 97 os process: request allocation n
11.2.0.4.0 98 ksir sga latch n
11.2.0.4.0 99 kspoltest latch n
11.2.0.4.0 100 ksz_so allocation latch n
11.2.0.4.0 101 reid allocation latch n
11.2.0.4.0 103 pmon tst latch n
11.2.0.4.0 104 pmon tst latch 2 n
11.2.0.4.0 105 queued dump request n
11.2.0.4.0 106 global hanganlyze operation n
11.2.0.4.0 107 ges process table freelist n
11.2.0.4.0 108 ges process parent latch n
11.2.0.4.0 109 ges process hash list n
11.2.0.4.0 110 ges resource table freelist n
11.2.0.4.0 111 ges caches resource lists n
11.2.0.4.0 112 ges resource hash list n
11.2.0.4.0 113 ges resource scan list n
11.2.0.4.0 114 ges s-lock bitvec freelist n
11.2.0.4.0 115 ges enqueue table freelist n
11.2.0.4.0 116 ges dfs wait callback info n
11.2.0.4.0 117 ges timeout list n
11.2.0.4.0 118 ges deadlock list n
11.2.0.4.0 119 ges statistic table n
11.2.0.4.0 120 ges synchronous data n
11.2.0.4.0 121 kjc message pool free list n
11.2.0.4.0 122 kjc receiver ctx free list n
11.2.0.4.0 123 kjc snd proxy ctx free list n
11.2.0.4.0 124 kjc destination ctx free list n
11.2.0.4.0 125 kjc receiver queue access list n
11.2.0.4.0 126 kjc snd proxy queue access list n
11.2.0.4.0 127 kjc global resend message queue n
11.2.0.4.0 128 kjct receiver queue access n
11.2.0.4.0 129 kjct flow control latch n
11.2.0.4.0 130 kjc global post event buffer n
11.2.0.4.0 131 ges domain table n
11.2.0.4.0 132 ges group table n
11.2.0.4.0 133 gcs resource hash n
11.2.0.4.0 134 gcs opaque info freelist n
11.2.0.4.0 135 gcs resource freelist n
11.2.0.4.0 136 gcs resource scan list n
11.2.0.4.0 137 gcs resource validate list n
11.2.0.4.0 138 gcs domain validate latch n
11.2.0.4.0 139 gcs shadows freelist n
11.2.0.4.0 140 gcs commit scn state n
11.2.0.4.0 141 name-service entry n
11.2.0.4.0 142 name-service request queue n
11.2.0.4.0 143 name-service pending queue n
11.2.0.4.0 145 name-service memory objects n
11.2.0.4.0 146 name-service namespace objects n
11.2.0.4.0 147 name-service request n
11.2.0.4.0 148 name-service memory recovery n
11.2.0.4.0 152 gcs remaster request queue n
11.2.0.4.0 153 gcs affinity object freelist latch n
11.2.0.4.0 154 recovery domain freelist n
11.2.0.4.0 156 ges value block free list n
11.2.0.4.0 157 testing n
11.2.0.4.0 158 heartbeat check n
11.2.0.4.0 159 heartbeat structure management n
11.2.0.4.0 161 gcr structure management n
11.2.0.4.0 162 kmg mman ready and startup request latch n
11.2.0.4.0 163 kmg resize request state object freelist n
11.2.0.4.0 165 file number translation table n
11.2.0.4.0 166 mostly latch-free scn n
11.2.0.4.0 167 lgwr lwn scn n
11.2.0.4.0 168 redo on-disk scn n
11.2.0.4.0 169 ping redo on-disk scn n
11.2.0.4.0 170 consistent rba n
11.2.0.4.0 172 cache buffers lru chain n
11.2.0.4.0 174 multiple dbwriter suspend n
11.2.0.4.0 175 active checkpoint queue latch n
11.2.0.4.0 176 checkpoint queue latch n
11.2.0.4.0 178 cache buffer handles n
11.2.0.4.0 179 multiblock read objects n
11.2.0.4.0 180 cache protection latch n
11.2.0.4.0 181 block corruption recovery state n
11.2.0.4.0 182 parallel ibr array n
11.2.0.4.0 184 cache table scan latch n
11.2.0.4.0 185 simulator lru latch n
11.2.0.4.0 186 simulator hash latch n
11.2.0.4.0 187 sim partition latch n
11.2.0.4.0 188 state object free list n
11.2.0.4.0 190 object queue header heap n
11.2.0.4.0 191 archive control n
11.2.0.4.0 192 fal queue n
11.2.0.4.0 193 kcrrgapb latch n
11.2.0.4.0 194 recovery ping control n
11.2.0.4.0 195 rsga queue n
11.2.0.4.0 196 krsh_sga_uet latch n
11.2.0.4.0 197 managed standby recovery state n
11.2.0.4.0 198 sga kcrrlac latch n
11.2.0.4.0 199 sga kcrrgap latch n
11.2.0.4.0 200 real time apply boundary n
11.2.0.4.0 201 sga kcrrpinfo latch n
11.2.0.4.0 202 sga kcrrlatmscnl latch n
11.2.0.4.0 203 archive process latch n
11.2.0.4.0 204 lgwr ns write n
11.2.0.4.0 205 managed standby latch n
11.2.0.4.0 206 alert log latch n
11.2.0.4.0 207 redo writing n
11.2.0.4.0 208 redo copy n
11.2.0.4.0 209 redo allocation n
11.2.0.4.0 210 real redo scn n
11.2.0.4.0 211 write info latch n
11.2.0.4.0 212 readredo stats and histogram n
11.2.0.4.0 213 os file lock latch n
11.2.0.4.0 214 online datafile move latch n
11.2.0.4.0 216 gc checkpoint n
11.2.0.4.0 217 gc persistent rm n
11.2.0.4.0 218 loader state object freelist n
11.2.0.4.0 219 begin backup scn array n
11.2.0.4.0 220 krb spare1 latch n
11.2.0.4.0 221 krb spare2 latch n
11.2.0.4.0 222 krb spare3 latch n
11.2.0.4.0 223 krb spare4 latch n
11.2.0.4.0 224 krbmrosl n
11.2.0.4.0 225 krbabrstatl n
11.2.0.4.0 226 logminer work area n
11.2.0.4.0 227 logminer local n
11.2.0.4.0 228 logminer context allocation n
11.2.0.4.0 229 logical standby cache n
11.2.0.4.0 230 logical standby view n
11.2.0.4.0 231 media recovery process out of buffers n
11.2.0.4.0 232 read-only violation array modification n
11.2.0.4.0 233 mapped buffers lru chain n
11.2.0.4.0 234 media rcv so alloc latch n
11.2.0.4.0 235 parallel recoverable recovery n
11.2.0.4.0 236 block media rcv so alloc latch n
11.2.0.4.0 237 readable standby influx scn n
11.2.0.4.0 238 readable standby metadata redo cache n
11.2.0.4.0 239 readable standby lamport table n
11.2.0.4.0 240 rsb inst ckpt scn n
11.2.0.4.0 241 change tracking state change latch n
11.2.0.4.0 242 change tracking optimization scn n
11.2.0.4.0 243 change tracking consistent scn n
11.2.0.4.0 244 lock dba buffer during media recovery n
11.2.0.4.0 245 lock new checkpoint scn during media recovery n
11.2.0.4.0 246 reservation so alloc latch n
11.2.0.4.0 247 reserved space latch n
11.2.0.4.0 248 flashback marker cache n
11.2.0.4.0 249 flashback fba barrier n
11.2.0.4.0 250 flashback scn barrier n
11.2.0.4.0 251 hint flashback fba barrier n
11.2.0.4.0 252 flashback hint scn barrier n
11.2.0.4.0 253 flashback allocation n
11.2.0.4.0 254 flashback mapping n
11.2.0.4.0 255 flashback copy n
11.2.0.4.0 256 flashback sync request n
11.2.0.4.0 257 flashback prepare log info n
11.2.0.4.0 258 minimum flashback scn latch n
11.2.0.4.0 259 block new check invariant rollback scn latch n
11.2.0.4.0 260 flashback coordinator context latch n
11.2.0.4.0 261 file deallocation scn cache n
11.2.0.4.0 262 transportable db context latch n
11.2.0.4.0 263 cvmap freelist lock n
11.2.0.4.0 264 kcfis latch n
11.2.0.4.0 265 latch for sabmr requests triggered by queries n
11.2.0.4.0 266 io pool granule metadata list n
11.2.0.4.0 267 io pool granule list n
11.2.0.4.0 268 dml lock allocation n
11.2.0.4.0 269 dml lock allocation n
11.2.0.4.0 270 list of block allocation n
11.2.0.4.0 271 transaction allocation n
11.2.0.4.0 272 dummy allocation n
11.2.0.4.0 273 transaction branch allocation n
11.2.0.4.0 274 undo global data n
11.2.0.4.0 276 parallel txn reco latch n
11.2.0.4.0 277 intra txn parallel recovery n
11.2.0.4.0 278 undo hint latch n
11.2.0.4.0 279 resumable state object n
11.2.0.4.0 282 mql tracking latch n
11.2.0.4.0 284 change notification latch n
11.2.0.4.0 285 flashback archiver latch n
11.2.0.4.0 287 corrupted undo seg latch n
11.2.0.4.0 &
上一篇： 如何突破PHP程序员的技术瓶颈分析
下一篇： Spring Boot 2.0 升级指南