Database Administration (MOSC)

MOSC Banner

Question on resource_limit

edited Aug 26, 2018 5:05AM in Database Administration (MOSC) 15 commentsAnswered
Hi DBA Gurus,

For restricting the resources to some user; we have updated the parameters of the profile assigned to the user. This isn't working because the resource_limit parameter is set to 'FALSE". Now I decide to set the parameter to "TRUE". Before doing so; I need to know what else would be impacted by doing this.

1. Checked the v$resource_limit and found that the maximum utilization of all the parameters except smartio_overhead_memory; the maximum utilization is more whereas the initial_allocation is 0 and limit_value is UNLIMITED.
2. Checked the dba_hist_resource_limit; the above parameter is not in this view and as per the entries in this; the maximum utilization is always less than inital_allocation. The only paramters in this view are

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