gc current grant busy - cheeyoung/sqlplus-public GitHub Wiki
...
19 SQL ID: 2yv5xahhmr2aa Plan Hash: 0
+20
+21 insert into ind$(bo#,obj#,ts#,file#,block#,intcols,type#,flags,property,
+22 pctfree$,initrans,maxtrans,blevel,leafcnt,distkey,lblkkey,dblkkey,clufac,
+23 cols,analyzetime,samplesize,dataobj#,degree,instances,rowcnt,pctthres$,
+24 indmethod#,trunccnt,spare1,spare4,spare2,spare6)
+25 values
+26 (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,
+27 :22,decode(:23,1,null,:23),decode(:24,1,null,:24),:25, :32*256+:26,:27,:28,
+28 :29,:30,:31,:33)
...
31 call count cpu elapsed disk query current rows
32 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
33 Parse 0 0.00 0.00 0 0 0 0
34 Execute 1 0.03 238.66 0 2 3 1
35 Fetch 0 0.00 0.00 0 0 0 0
36 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
37 total 1 0.03 238.66 0 2 3 1
...
44 Elapsed times include waiting on following events:
45 Event waited on Times Max. Wait Total Waited
46 ---------------------------------------- Waited ---------- ------------
47 gc current grant busy 1 238.65 238.65
...
...
+183 SQL ID: 4bjwv5sp99589 Plan Hash: 0
+184
+185 insert into obj$(owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,
+186 remoteowner,linkname,subname,dataobj#,flags,oid$,spare1,spare2,spare3)
+187 values
+188 (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18)
+189
+190
+191 call count cpu elapsed disk query current rows
+192 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
+193 Parse 0 0.00 0.00 0 0 0 0
+194 Execute 3 0.01 65.08 7 5 88 3
+195 Fetch 0 0.00 0.00 0 0 0 0
+196 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
+197 total 3 0.01 65.08 7 5 88 3
+198
+199 Misses in library cache during parse: 0
+200 Optimizer mode: CHOOSE
+201 Parsing user id: SYS (recursive depth: 1)
+202
+203 Elapsed times include waiting on following events:
+204 Event waited on Times Max. Wait Total Waited
+205 ---------------------------------------- Waited ---------- ------------
+206 gc current grant busy 11 65.03 65.04
+207 gc current grant 2-way 2 0.00 0.00
...
+235 SQL ID: g7mt7ptq286u7 Plan Hash: 0
+236
+237 insert into seg$ (file#,block#,type#,ts#,blocks,extents,minexts,maxexts,
+238 extsize,extpct,user#,iniexts,lists,groups,cachehint,hwmincr, spare1,
+239 scanhint, bitmapranges)
+240 values
+241 (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,DECODE(:17,0,NULL,
+242 :17),:18,:19)
+243
+244
+245 call count cpu elapsed disk query current rows
+246 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
+247 Parse 1 0.00 0.00 0 0 0 0
+248 Execute 2 0.01 14.43 0 6 53 2
+249 Fetch 0 0.00 0.00 0 0 0 0
+250 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
+251 total 3 0.01 14.43 0 6 53 2
+252
...
+264 Elapsed times include waiting on following events:
+265 Event waited on Times Max. Wait Total Waited
+266 ---------------------------------------- Waited ---------- ------------
+267 gc current grant 2-way 3 0.00 0.00
+268 Disk file operations I/O 1 0.00 0.00
+269 gc current grant busy 2 13.56 14.43
+270 ********************************************************************************
...
The message-related wait event statistics indicate that no block was received, because it was not cached in any instance. Instead, a global grant was given, enabling the requesting instance to read the block from disk, or to modify it.
Contention-Related Wait Events
The gc current block busy and gc cr block busy wait events indicate that the local instance that is making the request did not immediately receive a current or consistent read block. The term busy in these events names indicates that the sending of the block was delayed on a remote instance. For example, a block cannot be shipped immediately if Oracle Database has not yet written the redo for the block's changes to a log file.