Increase Oracle Process
select
resource_name,
current_utilization,
max_utilization,
limit_value
from v$resource_limit
where resource_name in ('sessions', 'processes');
editing
RESOURCE_NAME
--------------------------------------------------------------------------------
CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------------- --------------- ------------------------------
processes
106 117 350
sessions
113 135 548
alter system set processes=750 scope=spfile;
alter system set sessions=1152 scope=spfile;
shutdown immediate
startup
RESOURCE_NAME
--------------------------------------------------------------------------------
CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE
------------------- --------------- ------------------------------
processes
137 160 750
sessions
138 195 1152
Comments
Post a Comment