-
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..?
-
Have a look at the Oracle Doc. There you ll find all you need:
http://download-uk.oracle.com/docs/c...ory.htm#i47865
-
select sum(s.value) from v$sesstat s, v$statname n
where n.name='session pga memory'
and s.statistic# = n.statistic#;
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|