Number of Sessions = Number of User Connections (Foreground Processes)
Number of Processes ≥ Number of Sessions
You may leave SESSIONS and let Database choose its value automatically !
TRANSACTIONS = (1.1 * SESSIONS)
count:- select count(process) from gv$session where status='ACTIVE' or status='INACTIVE';
processes=x
session=(1.5 * PROCESSES) + 22
transactions=sessions*1.1
select inst_id, resource_name, current_utilization, max_utilization from gv$resource_limit
where resource_name in ('session', 'processes', 'transaction');
No comments:
Post a Comment