PGA – HOW ORACLE ALLOCATE MEMORY TO THE PROCESS?   In modern Oracle database none is allocating memory to the process manual, almost everybody uses automatic workload allocation, by setting pga_aggregate_target. But how does Oracle split that memory to processes? Well, as we all know none of the process can have all of pga_aggregate_target memory […]