Database Administration (MOSC)

MOSC Banner

v$resource_limit's output seems inconsistent

edited May 26, 2010 5:21AM in Database Administration (MOSC) 2 commentsAnswered
Hello. I am running the following SQL against oracle 10.2.0.3

  1  select
  2  RESOURCE_NAME,
  3  CURRENT_UTILIZATION,
  4  MAX_UTILIZATION,
  5  INITIAL_ALLOCATION,
  6  LIMIT_VALUE
  7   from v$resource_limit
  8* where resource_name = 'parallel_max_servers'

RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU
------------------------------ ------------------- --------------- ---------- ----------
parallel_max_servers                           309             645        384       3600

I am not sure what it means. I currently have 309 parallel slave processes; the max number is 645 and my allocation is 384. How can the max number of parallel slaves reach 645 if the value of the parameter is 384?

Am I misinterpreting this somehow?

thank you

Gene

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