Database Administration (MOSC)

MOSC Banner

In V$RESOURCE_LIMIT how different values comes in some specific columns

edited Mar 6, 2020 12:25PM in Database Administration (MOSC) 11 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center