Re: Performance Issues with SQL Queries

Posted by prabhunoule on Oct 31, 2023; 5:59am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Performance-Issues-with-SQL-Queries-tp12136p12140.html

Hi Erman,

We have 2 node RAC with 4 core in each server. We have 250 GB RAM.
Our SGA and PGA are as below.
SQL> sho parameter SGA
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 25G
sga_target big integer 25G
SQL> sho parameter PGA
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 0
pga_aggregate_target big integer 5G


Currently we have sessions 1600 and processes 800. Can you advice, with this configuration, how many processes will this server support?




Thanks & Regards,
Prabhu