How to know how much PGA is getting used at particular point in time..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to know how much PGA is getting used at particular point in time..

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    How to know how much PGA is getting used at particular point in time..

    Hi ,

    Any idea how to know , how much PGA is getting used at particular point in time..?

  2. #2
    Join Date
    Mar 2002
    Posts
    534
    Have a look at the Oracle Doc. There you ll find all you need:

    http://download-uk.oracle.com/docs/c...ory.htm#i47865

  3. #3
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    select sum(s.value) from v$sesstat s, v$statname n
    where n.name='session pga memory'
    and s.statistic# = n.statistic#;

  4. #4
    Join Date
    Mar 2002
    Posts
    534
    SELECT * FROM V$PGASTAT;

    SELECT PROGRAM, PGA_USED_MEM, PGA_ALLOC_MEM, PGA_FREEABLE_MEM, PGA_MAX_MEM
    FROM V$PROCESS;

    SELECT * FROM V$PROCESS_MEMORY;


    SELECT * FROM V$SQL_WORKAREA_ACTIVE;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width