Database Administration (MOSC)

MOSC Banner

v$resource_limit for PDB

19.16 database, Solaris Sparc 64

I'm running this query, and I don't get any rows returned (on a non-Root container)

I do when I query from the Root container. I know the "sessions" and the "parallel_max_servers" parameter can be set for non-Root container, so, it should report some values. The database is running for a week now, not just started.


select con_id,resource_name, current_utilization, max_utilization high_utilization

 from v$resource_limit where resource_name in ('processes','sessions','parallel_max_servers');


Why doesn't he return values for these ?

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