Display information about the procedure cache (in table format)
Syntax DBCC PROCCACHE [WITH NO_INFOMSGS] Key: NO_INFOMSGS - Suppress all information messages (severity 0-10)
All output figures are Totals:
proc cache size
Entries in the procedure cache.
proc cache used
Entries that are currently being used.
num proc buffs
Pages used by all entries in the procedure cache.
num proc buffs used
Pages used by all entries that are currently being used.
proc cache active / num proc buffs active
For backward compatibility only.
“Misrepresentation and deception are standard operating procedure for this administration, which - to an extent never before seen in U.S. history - systematically and brazenly distorts the facts.” - Paul Krugman (NY Times)
Equivalent Oracle command:
Select from V$SYSSTAT