The more
users and sessions are connected to a
instance, the more important the management of the resources offered by the instance becomes crucial.
Resource management deals with assigning the available resources to user accounts, applications and services. A session that consumes too much resources can be slowed down or trimmed back so that other sessions are less impacted by a bottleneck of resources.
Oracle provides
DBAs with
dbms_resource_manager
to administrate resource allocation. For example, it's possible to assign more percent of the available CPU time to
OLTP processes than to
OLAP processes because OLTP is usually more time critical.