Showing posts with label relations between process. Show all posts
Showing posts with label relations between process. Show all posts

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');

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...