X hits on this document

148 views

0 shares

0 downloads

0 comments

20 / 38

20

juliandyke.com

© 2007 Julian Dyke

Result Cache Dynamic Performance Views

V$RESULT_CACHE_STATISTICS

Based on X$QESRCSTA

One row for each statistic

V$RESULT_CACHE_OBJECTS

Based on X$QESRCOBJ

One row for each object (result set or dependency object) in result cache

V$RESULT_CACHE_MEMORY

Based on X$QESRCMEM

One row for each block in result cache

V$RESULT_CACHE_DEPENDENCY

Based on X$QESRCDEP

One row for each dependency between a result set and a data dictionary object

Each V$ view has an equivalent GV$ view

Document info
Document views148
Page views150
Page last viewedSun Jan 22 12:49:26 UTC 2017
Pages38
Paragraphs703
Words2667

Comments