[20190416]11g下那些latch是Exclusive的.txt

来源：这里教程网时间：2026-03-03 13:18:06 作者：

[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 288 sort extent pool N 11.2.0.4.0 292 fast space usage latch N 11.2.0.4.0 293 shrink stat allocation latch N 11.2.0.4.0 294 file cache latch N 11.2.0.4.0 295 ktm global data N 11.2.0.4.0 297 space background task latch N 11.2.0.4.0 298 space background state object latch N 11.2.0.4.0 299 sequence cache N 11.2.0.4.0 300 temp lob duration state obj allocation N 11.2.0.4.0 302 File State Object Pool Parent Latch N 11.2.0.4.0 303 Write State Object Pool Parent Latch N 11.2.0.4.0 304 deferred cleanup latch N 11.2.0.4.0 307 Locator state objects pool parent latch N 11.2.0.4.0 309 row cache objects N 11.2.0.4.0 310 KQF runtime table column alloc N 11.2.0.4.0 311 KQF runtime purge top lvl latch N 11.2.0.4.0 312 QOL Name Generation Latch N 11.2.0.4.0 313 kkae edition name cache N 11.2.0.4.0 314 KKCN reg stat latch N 11.2.0.4.0 315 KKCN grp reg latch N 11.2.0.4.0 316 KKCN grp data latch N 11.2.0.4.0 319 cost function N 11.2.0.4.0 329 first Audit Vault latch N 11.2.0.4.0 330 second Audit Vault latch N 11.2.0.4.0 333 global tx hash mapping N 11.2.0.4.0 334 k2q lock allocation N 11.2.0.4.0 335 k2q global data latch N 11.2.0.4.0 336 shared pool N 11.2.0.4.0 337 library cache load lock N 11.2.0.4.0 338 Token Manager N 11.2.0.4.0 339 cas latch N 11.2.0.4.0 340 rm cas latch N 11.2.0.4.0 341 resmgr:actses change state N 11.2.0.4.0 342 resmgr:actses change group N 11.2.0.4.0 343 resmgr:session queuing N 11.2.0.4.0 345 resmgr:schema config N 11.2.0.4.0 346 resmgr:vc list latch N 11.2.0.4.0 347 resmgr:incr/decr stats N 11.2.0.4.0 348 resmgr:method mem alloc latch N 11.2.0.4.0 350 resmgr:resource group CPU method N 11.2.0.4.0 351 QMT N 11.2.0.4.0 352 shared pool simulator N 11.2.0.4.0 353 shared pool sim alloc N 11.2.0.4.0 354 Streams Generic N 11.2.0.4.0 358 Memory Queue Message Subscriber #1 N 11.2.0.4.0 359 Memory Queue Message Subscriber #2 N 11.2.0.4.0 360 Memory Queue Message Subscriber #3 N 11.2.0.4.0 361 Memory Queue Message Subscriber #4 N 11.2.0.4.0 362 pesom_hash_node N 11.2.0.4.0 363 pesom_free_list N 11.2.0.4.0 364 pesom_heap_alloc N 11.2.0.4.0 365 peshm N 11.2.0.4.0 366 Mutex N 11.2.0.4.0 367 Mutex Stats N 11.2.0.4.0 368 pebof_rrv N 11.2.0.4.0 370 KGNFS-NFS:SHM structure N 11.2.0.4.0 371 kgnfs mount latch N 11.2.0.4.0 372 KGNFS-NFS:SVR LIST N 11.2.0.4.0 374 SGA heap locks N 11.2.0.4.0 376 SGA pool locks N 11.2.0.4.0 377 SGA bucket locks N 11.2.0.4.0 379 SGA blob parent N 11.2.0.4.0 381 kgb parent N 11.2.0.4.0 384 SGA slab metadata lock N 11.2.0.4.0 386 shared server configuration N 11.2.0.4.0 387 session timer N 11.2.0.4.0 388 parameter list N 11.2.0.4.0 389 presentation list N 11.2.0.4.0 390 address list N 11.2.0.4.0 391 end-point list N 11.2.0.4.0 392 shared server info N 11.2.0.4.0 393 dispatcher info N 11.2.0.4.0 394 virtual circuit buffers N 11.2.0.4.0 395 virtual circuit queues N 11.2.0.4.0 396 virtual circuits N 11.2.0.4.0 397 virtual circuit holder N 11.2.0.4.0 398 kmcptab latch N 11.2.0.4.0 399 kmcpvec latch N 11.2.0.4.0 400 cp pool array latch N 11.2.0.4.0 401 cp cmon array latch N 11.2.0.4.0 402 cp server array latch N 11.2.0.4.0 403 cp server hash latch N 11.2.0.4.0 404 cp cso latch N 11.2.0.4.0 405 cp pool latch N 11.2.0.4.0 406 cp cmon/server latch N 11.2.0.4.0 407 cp holder latch N 11.2.0.4.0 408 cp sga latch N 11.2.0.4.0 411 job_queue_processes parameter latch N 11.2.0.4.0 412 job workq parent latch N 11.2.0.4.0 413 job_queue_processes free list latch N 11.2.0.4.0 414 query server process N 11.2.0.4.0 415 query server freelists N 11.2.0.4.0 416 error message lists N 11.2.0.4.0 417 process queue N 11.2.0.4.0 418 process queue reference N 11.2.0.4.0 419 parallel query stats N 11.2.0.4.0 420 business card N 11.2.0.4.0 421 queuing load statistics N 11.2.0.4.0 422 parallel query alloc buffer N 11.2.0.4.0 423 PX hash array latch N 11.2.0.4.0 424 hash table modification latch N 11.2.0.4.0 427 constraint object allocation N 11.2.0.4.0 428 device information N 11.2.0.4.0 429 temporary table state object allocation N 11.2.0.4.0 430 internal temp table object number allocation latch N 11.2.0.4.0 431 SQL memory manager latch N 11.2.0.4.0 432 SQL memory manager workarea list latch N 11.2.0.4.0 434 Bloom filter list latch N 11.2.0.4.0 435 Bloom Filter SGA latch N 11.2.0.4.0 437 Result Cache: SO Latch N 11.2.0.4.0 438 Result Cache: MB Latch N 11.2.0.4.0 439 Statement queuing latch N 11.2.0.4.0 440 Statement Queuing SGA latch N 11.2.0.4.0 441 kupp process latch N 11.2.0.4.0 442 pass worker exception to master N 11.2.0.4.0 443 datapump job fixed tables latch N 11.2.0.4.0 444 datapump attach fixed tables latch N 11.2.0.4.0 445 process N 11.2.0.4.0 446 VPSO SGA N 11.2.0.4.0 447 STREAMS LCR N 11.2.0.4.0 448 STREAMS: txn btree N 11.2.0.4.0 449 STREAMS Pool Advisor N 11.2.0.4.0 450 kokc descriptor allocation latch N 11.2.0.4.0 451 ncodef allocation latch N 11.2.0.4.0 452 NLS data objects N 11.2.0.4.0 453 kpon job info latch N 11.2.0.4.0 454 kpon sga structure N 11.2.0.4.0 455 reg$ timeout service time N 11.2.0.4.0 456 KPON ksr channel latch N 11.2.0.4.0 457 EMON slave state object latch N 11.2.0.4.0 458 session state list latch N 11.2.0.4.0 459 kpplsSyncStateListSga: lock N 11.2.0.4.0 460 connection pool sga data lock N 11.2.0.4.0 461 message enqueue sync latch N 11.2.0.4.0 462 image handles of buffered messages latch N 11.2.0.4.0 463 kwqi:kchunk latch N 11.2.0.4.0 469 job queue sob latch N 11.2.0.4.0 470 rules engine aggregate statistics N 11.2.0.4.0 473 rules engine evaluation context statistics N 11.2.0.4.0 474 enqueue sob latch N 11.2.0.4.0 475 kwqbsgn:msghdr N 11.2.0.4.0 476 kwqbsn:qxl N 11.2.0.4.0 478 kwqbcco:cco N 11.2.0.4.0 480 spilled messages latch N 11.2.0.4.0 483 qmn task queue latch N 11.2.0.4.0 484 qmn task context latch N 11.2.0.4.0 485 qmn state object latch N 11.2.0.4.0 488 AQ deq hash table latch N 11.2.0.4.0 489 AQ dequeue txn counter latch N 11.2.0.4.0 490 AQ disk delete txn counter latch N 11.2.0.4.0 491 AQ small txn context latch N 11.2.0.4.0 492 AQ deq log statistics latch N 11.2.0.4.0 493 AQ deq log cmt cbk chunk latch N 11.2.0.4.0 494 AQ ht cmt cbk chunk latch N 11.2.0.4.0 495 fixed table rows for x$hs_session N 11.2.0.4.0 496 qm_init_sga N 11.2.0.4.0 497 XDB unused session pool N 11.2.0.4.0 498 XDB used session pool N 11.2.0.4.0 499 XDB Config-1 N 11.2.0.4.0 500 XDB Config-2 N 11.2.0.4.0 501 XDB Config-3 N 11.2.0.4.0 502 qmtmrcsg_init N 11.2.0.4.0 503 XML DB Events N 11.2.0.4.0 506 XDB NFS Security Latch N 11.2.0.4.0 509 XDB PL/SQL Support N 11.2.0.4.0 510 DMON Work Queues Latch N 11.2.0.4.0 511 DMON Network Error List Latch N 11.2.0.4.0 512 RSM process latch N 11.2.0.4.0 513 NSV command ID generation latch N 11.2.0.4.0 514 NSV creation/termination latch N 11.2.0.4.0 515 Request id generation latch N 11.2.0.4.0 516 Fast-Start Failover State Latch N 11.2.0.4.0 517 xscalc freelist N 11.2.0.4.0 518 xssinfo freelist N 11.2.0.4.0 519 AW SGA latch N 11.2.0.4.0 520 ASM allocation N 11.2.0.4.0 521 KFA SGA latch N 11.2.0.4.0 522 buffer pin latch N 11.2.0.4.0 523 KFC SGA latch N 11.2.0.4.0 524 KFC LRU latch N 11.2.0.4.0 525 KFC Hash Latch N 11.2.0.4.0 526 KFC FX Hash Latch N 11.2.0.4.0 527 ASM map headers N 11.2.0.4.0 528 ASM map operation freelist N 11.2.0.4.0 529 ASM map operation hash table N 11.2.0.4.0 530 ASM map load waiting list N 11.2.0.4.0 531 KFK SGA Libload latch N 11.2.0.4.0 532 ASM Keyed state latch N 11.2.0.4.0 533 Lsod array latch N 11.2.0.4.0 534 I/O Staticstics latch N 11.2.0.4.0 535 KFM allocation N 11.2.0.4.0 536 KFMD SGA N 11.2.0.4.0 537 ASM network background latch N 11.2.0.4.0 538 ASM network SGA latch N 11.2.0.4.0 539 ASM network state latch N 11.2.0.4.0 540 ASM db client latch N 11.2.0.4.0 541 ASM file locked extent latch N 11.2.0.4.0 542 ASM scan context latch N 11.2.0.4.0 543 ASM file allocation latch N 11.2.0.4.0 544 KFR redo allocation latch N 11.2.0.4.0 545 ASM rollback operations N 11.2.0.4.0 546 KFCL LE Freelist N 11.2.0.4.0 547 KFCL Instance Latch N 11.2.0.4.0 548 KFCL BX Freelist N 11.2.0.4.0 549 ASM attribute latch N 11.2.0.4.0 550 ASM Volume process latch N 11.2.0.4.0 551 ASM Volume SGA latch N 11.2.0.4.0 552 OFS SGA Latch N 11.2.0.4.0 553 ASM user latch N 11.2.0.4.0 554 ASM KFFD SO Latch N 11.2.0.4.0 555 server alert latch N 11.2.0.4.0 556 generalized trace enabling latch N 11.2.0.4.0 557 statistics aggregation N 11.2.0.4.0 558 AWR Alerted Metric Element list N 11.2.0.4.0 559 threshold alerts latch N 11.2.0.4.0 560 WCR: kecu cas mem N 11.2.0.4.0 561 WCR: kecr File Count N 11.2.0.4.0 562 WCR: MMON Create dir N 11.2.0.4.0 563 Real-time plan statistics latch N 11.2.0.4.0 564 WCR: ticker cache N 11.2.0.4.0 567 WCR: MTS VC queue N 11.2.0.4.0 568 JS broadcast add buf latch N 11.2.0.4.0 569 JS broadcast drop buf latch N 11.2.0.4.0 570 JS broadcast kill buf latch N 11.2.0.4.0 571 JS broadcast load blnc latch N 11.2.0.4.0 572 JS broadcast autostart latch N 11.2.0.4.0 573 JS broadcast LW Job latch N 11.2.0.4.0 574 JS mem alloc latch N 11.2.0.4.0 575 JS slv state obj latch N 11.2.0.4.0 576 JS queue state obj latch N 11.2.0.4.0 577 JS queue access latch N 11.2.0.4.0 580 dbkea msgq latch N 11.2.0.4.0 581 KXDAM sga state latch N 481 rows selected. SYS@book> select count(*) from exclusive_latches ; COUNT(*) ---------- 481 SYS@book> select count(*) from shared_latches; COUNT(*) ---------- 101 SYS@book> select count(*) from v$latch ; COUNT(*) ---------- 582 SYS@book> select name from v$latch minus (select name from exclusive_latches union all select name from shared_latches); no rows selected --//可以确定是shared就不可能是exclusive.