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?
Exhibit:

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 parameters are not set in the initialization parameter file



Leave a Reply 0

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