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

Enable OpenSSH on Windows 11

Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...