5 Replies Latest reply: Aug 26, 2014 9:11 AM by Bhanu.Oradba-Oracle RSS

    PGA Allocation size

    975791

      Hi,

       

      Version : 11.2

       

      All SGA components allocate and deallocate space in units of granules.What about PGA to allocate space to process?

      Is there any hidden parameter for PGA?

       

      Thanks,

        • 1. Re: PGA Allocation size
          sol.beach

          >What about PGA to allocate space to process?

           

          what about it?

           

          >Is there any hidden parameter for PGA?

          no

           

          why does it matter?

          • 2. Re: PGA Allocation size
            975791

            Hi,

             

            Thanks.

             

            Howmuch space oracle allocate to a process (Sql Work Area,Session Memory,Private Sql Area) in PGA?

            Is there any minimum value?

             

            thanks

            • 3. Re: PGA Allocation size
              JohnWatson

              975791 wrote:

               

              <snip>

              Is there any hidden parameter for PGA?

               

              Thanks,

              orclz>

              orclz> select ksppinm from x$ksppi where ksppinm like '%pga%';

               

              KSPPINM

              --------------------------------------------------------------------------------

              _pga_large_extent_size

              _use_ism_for_pga

              _pga_limit_target_perc

              _pga_limit_watch_perc

              _pga_limit_time_to_interrupt

              _pga_limit_interrupt_smaller

              _pga_limit_time_until_idle

              _pga_limit_time_until_killed

              _pga_limit_use_immediate_kill

              _pga_limit_dump_summary

              _pga_limit_watch_size

              _pga_limit_min_req_size

              _pga_limit_check_wait_time

              _pga_limit_simulated_physmem_size

              pga_aggregate_limit

              _pga_limit_tracing

              _ldr_pga_lim

              _kdli_sio_pga

              _kdli_sio_pga_top

              _pgactx_cap_stacks

              pga_aggregate_target

              __pga_aggregate_target

              _pga_max_size

               

              23 rows selected.

               

              orclz>


              Enjoy.

              • 4. Re: PGA Allocation size
                sol.beach

                975791 wrote:

                 

                Hi,

                 

                Thanks.

                 

                Howmuch space oracle allocate to a process (Sql Work Area,Session Memory,Private Sql Area) in PGA?

                Is there any default value?

                 

                thanks

                initially 0

                 

                why does it matter to you?

                • 5. Re: PGA Allocation size
                  Bhanu.Oradba-Oracle

                  You can check allocated pga per session from v$process view.

                   

                  select pid, spid, serial#, username, pga_alloc_mem, pga_used_mem from v$process;

                   

                  Thanks,

                  Bhanu