In V$RESOURCE_LIMIT how different values comes in some specific columns
Hi,
My question is In V$RESOURCE_LIMIT how different values comes in some specific columns. Let me explain it.
we are here talking about two specific columns of V$RESOURCE_LIMIT.
INITIAL_ALLOCATION
LIMIT_VALUE
As per oracle docu INITIAL_ALLOCATION
value comes from parameter file and LIMIT_VALUE
is maximum and INITIAL_ALLOCATION
cant go beyond LIMIT_VALUE
.
My questions are :
1) if INITIAL_ALLOCATION
takes from parameter file, how the LIMIT_VALUE
is allocating ?
2) Shall I change the LIMIT_VALUE
as per my wish ? If yes How (Via alter system/session) ?
I have seen some LIMIT_VALUE
are not UNLIMTED and changing the values when we change the parameters with Alter system/session.