PGA를 사용하는 사용량 확인은 간단히 v$sesstat 뷰와 v$statname 뷰를 조인하면 된다.
자신이 사용하는 pga 사용량을 확인하기 위해서는 추가적으로 v$mystat뷰와 조인을 하면된다.
SELECT m.name , t.value
FROM v$sesstat t,
v$statname m
WHERE t.statistic# = m.statistic#
AND m.name like ‘%pga%’
AND t.sid = ( SELECT distinct sid FROM v$mystat) ;
NAME VALUE
——————————- ————
session pga memory 1105492
session pga memory max 3333716
자신이 아닌 다른 사람의 PGA사용량을 보기 위해선 sid값에 다른 사람의 sid 값을 넣어주면 됨
I loved as much as you will receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get got an shakiness over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly a lot often inside case you shield this increase.
Definitely believe that which you stated. Your favorite justification seemed to be on the internet the simplest thing to be aware of. I say to you, I definitely get irked while people think about worries that they just don’t know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side effect , people can take a signal. Will probably be back to get more. Thanks
You can definitely see your enthusiasm in the work you write. The arena hopes for even more passionate writers such as you who are not afraid to mention how they believe. At all times go after your heart.