Why do INITIAL_SIZE, TARGET_SIZE, and FINAL_SIZE columns have the value zero for some of the components?

View the Exhibit and analyze the output of a query executed on the V$MEMORY_RESIZE_OPS
view. Why do INITIAL_SIZE, TARGET_SIZE, and FINAL_SIZE columns have the value zero for
some of the components?

View the Exhibit and analyze the output of a query executed on the V$MEMORY_RESIZE_OPS
view. Why do INITIAL_SIZE, TARGET_SIZE, and FINAL_SIZE columns have the value zero for
some of the components?

A.
because they are the only components that are auto-tuned

B.
because they are the only components that are not auto-tuned

C.
because they are the only components that have not undergone any manual resizing

D.
because they are the only components that do not have a default size or their respective
parametersare not set in the initialization parameter file



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

No default and no set in init

So D is right