Differences

This shows you the differences between two versions of the page.

--- configuration [2019/01/30 11:32] – external edit 127.0.0.1
+++ configuration [2019/02/02 13:43] (current) – stuart
@@ Line 1: / Line 1: @@
   * [[init.ora]]
+  * [[Install Oracle software, run netca and dbca without gui (silent option)]]
-  *  [[Install Oracle software, run netca and dbca without gui (silent option)]]
+==== Consequences on PGA of increasing processes parameter ====
+If your database is running out of processes, increase the value along with sessions and transactions. But spare a thought for the PGA.
+<code>
+select max(p.pga_max_mem)/1024/1024 "PGA max process (MB)"
+from   v$process p
+,      v$session s
+where  p.addr = s.paddr
+and    s.username is not null;
+</code>
+<code>
+PGA max process (MB)
+--------------------
+.203085
+</code>
+This shows the maximum amount of PGA used by an active process.\\
+Now work out the total possible amount that could be used by the new value of processes.
+<code>
+select name
+,      value
+from   v$parameter
+where  name = 'processes';
+</code>
+<code>
+NAME                 VALUE
+-------------------- ----------
+processes            4000
+</code>
+So 140Mb * 4000 is about 560Gb which is a lot! So either a lot more space (may) be needed for the PGA or the processes need to come down.\\
+As an aside, this gets the total SGA:
+<code>
+select sum(value)/1024/1024 "Total SGA (MB)" from v$sga;
+</code>