来自 技术 2019-04-17 的文章

[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 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.

标签:   建网站 广州      阿里大鱼短信sdk   
上一篇:PS中ctrl+t是什么快捷键?
下一篇:没有了