Rostener segue os results …. veja se tenho que fazer os ajustens como vc mencionou na mensagem anterior …
SQL> select
2 sum(value)/1024/1024 Mb
3 from
4 v$sesstat s, v$statname n
5 where
6 n.STATISTIC# = s.STATISTIC# and
7 name = ‘session pga memory’;
MB
41.1705551
SQL> select
2 sid,name,value
3 from
4 v$statname n,v$sesstat s
5 where
6 n.STATISTIC# = s.STATISTIC# and
7 name like ‘session%memory%’
8 order by 3 asc;
SID NAME VALUE
1 session uga memory 77008
104 session uga memory 77008
100 session uga memory 77008
97 session uga memory 77008
95 session uga memory 77008
88 session uga memory 77008
71 session uga memory 77008
66 session uga memory 77008
99 session uga memory 77008
6 session uga memory 77008
4 session uga memory 77008
SID NAME VALUE
2 session uga memory 77008
9 session uga memory 77008
10 session uga memory 77008
11 session uga memory 77008
20 session uga memory 77008
22 session uga memory 77008
30 session uga memory 77008
95 session uga memory max 77008
97 session uga memory max 77008
99 session uga memory max 77008
100 session uga memory max 77008
SID NAME VALUE
104 session uga memory max 77008
1 session uga memory max 77008
3 session uga memory 77008
5 session uga memory 77008
7 session uga memory 77008
30 session uga memory max 77008
36 session uga memory max 77008
43 session uga memory max 77008
45 session uga memory max 77008
71 session uga memory max 77008
88 session uga memory max 77008
SID NAME VALUE
89 session uga memory max 77008
36 session uga memory 77008
43 session uga memory 77008
4 session uga memory max 77008
5 session uga memory max 77008
6 session uga memory max 77008
7 session uga memory max 77008
9 session uga memory max 77008
10 session uga memory max 77008
20 session uga memory max 77008
22 session uga memory max 77008
SID NAME VALUE
45 session uga memory 77008
2 session uga memory max 77008
3 session uga memory max 77008
89 session uga memory 77008
106 session uga memory 142472
11 session uga memory max 142472
66 session uga memory max 142472
52 session uga memory max 142472
17 session uga memory 142472
52 session uga memory 142472
42 session uga memory 207936
SID NAME VALUE
23 session uga memory 207936
1 session pga memory 208320
1 session pga memory max 208320
6 session pga memory 208320
7 session pga memory 208320
6 session pga memory max 208320
7 session pga memory max 208320
104 session pga memory 211996
95 session pga memory 211996
88 session pga memory 211996
66 session pga memory 211996
SID NAME VALUE
43 session pga memory 211996
30 session pga memory 211996
20 session pga memory max 211996
22 session pga memory max 211996
30 session pga memory max 211996
36 session pga memory max 211996
43 session pga memory max 211996
45 session pga memory max 211996
95 session pga memory max 211996
97 session pga memory max 211996
99 session pga memory max 211996
SID NAME VALUE
104 session pga memory max 211996
11 session pga memory 211996
20 session pga memory 211996
22 session pga memory 211996
36 session pga memory 211996
71 session pga memory max 211996
88 session pga memory max 211996
45 session pga memory 211996
71 session pga memory 211996
97 session pga memory 211996
99 session pga memory 211996
SID NAME VALUE
100 session pga memory 229020
89 session pga memory 229020
89 session pga memory max 229020
100 session pga memory max 229020
70 session uga memory 273400
8 session uga memory max 273400
8 session uga memory 273400
106 session pga memory 277532
52 session pga memory 277532
52 session pga memory max 277532
11 session pga memory max 277532
SID NAME VALUE
66 session pga memory max 277532
17 session pga memory 335176
92 session uga memory 338864
28 session uga memory 338864
28 session uga memory max 338864
42 session pga memory 411460
70 session pga memory 425640
8 session pga memory 496900
92 session pga memory 501192
23 session pga memory 516708
61 session uga memory 535256
SID NAME VALUE
5 session pga memory 537072
8 session pga memory max 562436
103 session uga memory 600720
28 session pga memory 605748
28 session pga memory max 605748
69 session uga memory 666184
103 session uga memory max 666184
61 session pga memory 720756
106 session uga memory max 731648
23 session uga memory max 731648
17 session uga memory max 731648
SID NAME VALUE
103 session pga memory 736284
103 session pga memory max 801820
69 session pga memory 850940
5 session pga memory max 864752
106 session pga memory max 867356
17 session pga memory max 925000
42 session uga memory max 928040
70 session uga memory max 993504
23 session pga memory max 1040996
42 session pga memory max 1123832
61 session uga memory max 1124432
SID NAME VALUE
70 session pga memory max 1146536
61 session pga memory max 1277608
69 session uga memory max 1517216
59 session uga memory 1648144
69 session pga memory max 1727848
4 session pga memory 1827668
4 session pga memory max 1827668
59 session pga memory 1916468
92 session uga memory max 2237428
92 session pga memory max 2598344
2 session pga memory 2734096
SID NAME VALUE
2 session pga memory max 2734096
59 session uga memory max 3481244
59 session pga memory max 3751476
3 session pga memory 8661204
3 session pga memory max 8661204
10 session pga memory 8676336
9 session pga memory 8676336
10 session pga memory max 8676336
9 session pga memory max 8676336
152 rows selected.
SQL> spool off
Att,
Marcelo