Tuesday, August 1, 2023

Relation between "processes, sessions and transactions" In Oracle Database

 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

opatchauto

# Log in as root su - root # Execute opatchauto against the unzipped patch directory /u01/app/19.0.0/ grid /OPatch/opatchauto apply /tmp/pat...