X hits on this document

104 views

0 shares

0 downloads

0 comments

24 / 38

24

juliandyke.com

© 2007 Julian Dyke

Result Cache Global Area (Fixed SGA) Dump

Search dump file for qesrc

ksllt qesrcLca_ [20019A3C, 20019AA0) = .... // Latch - Result Cache: Latch

ksllt qesrcLso_ [20019AA0, 20019B04) = .... // Latch - Result Cache: SO Latch

ub4 qesrceq_ [20019B04, 20019B08) = 0000007B // Enqueue - RC - Result Cache: Enqueue

ub4 qesrceq1_ [20019B08, 20019B0C) = 00000090 //

sword qesrceq1_e_ [20019B0C, 20019B10) = 00000113 // Wait Event - enq: RC - Result Cache: Contention

word qesrcsot_ [20019B10, 20019B14) = 0000005A //

qesrcSGAt qescrSGA_ [20019B14, 20019B18) = 36FC1EE0 // Address of Result Cache SGA Memory area

ksdbp qesrcbg_ [20019B18, 20019B50) = ........ // Background Process - RCBG

ALTER SESSION SET EVENTS

'immediate trace name global_area level 2'

Cache Manager

Document info
Document views104
Page views104
Page last viewedThu Dec 08 09:58:09 UTC 2016
Pages38
Paragraphs703
Words2667

Comments