[20190416]11g下那些latch是Exclusive的.txt--//昨天測試了11g下那些latch是共用的,鏈接:--//是否反過來剩下的都是Exclusive的.繼續測試:1.環境:SYS@book> @ ver1PORT_STRING VERSION BANNER x86_64/L ...
[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
