LAST_OPER_TYPE column in v$sga_dynamic_components
Why does the LAST_OPER_TYPE column in v$sga_dynamic_components always contain the value INITIALIZING for the "DEFAULT 16K buffer cahce" row?
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.