Why does the LAST_OPER_TYPE column in v$sga_dynamic_components always contain the value INITIALIZING for the "DEFAULT 16K buffer cahce" row?
According to the Oracle docs this field can have the values STATIC, INITIALIZING, DISABLED, GROW, SHRINK and SHRINK_CANCEL. Our default buffer cache size is 4K, but we have two tablespaces that have a 16K block size.
By "always" I mean that I queried it a few times today and always saw this value.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.