X hits on this document

82 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 views82
Page views82
Page last viewedSat Dec 03 00:33:32 UTC 2016
Pages38
Paragraphs703
Words2667

Comments