|
Session Statistics (By Session)
|
| Username (1) |
SID (2) |
Statistic |
Usage (3) |
| STEWARTM |
17 |
session pga memory max |
76,592 |
| STEWARTM |
17 |
session pga memory |
76,592 |
| STEWARTM |
17 |
session uga memory max |
28,168 |
| STEWARTM |
17 |
session uga memory |
23,928 |
| STEWARTM |
17 |
bytes received via SQL*Net from client |
3,811 |
| STEWARTM |
17 |
bytes sent via SQL*Net to client |
2,094 |
| STEWARTM |
17 |
SQL*Net roundtrips to/from client |
46 |
| STEWARTM |
17 |
user calls |
40 |
| STEWARTM |
17 |
session logical reads |
26 |
| STEWARTM |
17 |
no work - consistent read gets |
18 |
| STEWARTM |
17 |
consistent gets |
18 |
| STEWARTM |
17 |
parse count |
17 |
| STEWARTM |
17 |
execute count |
16 |
| STEWARTM |
17 |
recursive calls |
15 |
| STEWARTM |
17 |
cursor authentications |
11 |
| STEWARTM |
17 |
session cursor cache count |
10 |
| STEWARTM |
17 |
calls to get snapshot scn: kcmgss |
9 |
| STEWARTM |
17 |
opened cursors cumulative |
9 |
| STEWARTM |
17 |
calls to kcmgrs |
9 |
| STEWARTM |
17 |
db block gets |
8 |
| STEWARTM |
17 |
session cursor cache hits |
4 |
| STEWARTM |
17 |
table scans (short tables) |
4 |
| STEWARTM |
17 |
table fetch by rowid |
3 |
| STEWARTM |
17 |
table scan blocks gotten |
2 |
| STEWARTM |
17 |
table scan rows gotten |
2 |
| STEWARTM |
17 |
logons cumulative |
1 |
| STEWARTM |
17 |
free buffer requested |
1 |
| STEWARTM |
17 |
opened cursors current |
1 |
| STEWARTM |
17 |
physical reads |
1 |
| STEWARTM |
17 |
logons current |
1 |
| STEWARTM |
17 |
sorts (rows) |
1 |
| STEWARTM |
17 |
sorts (memory) |
1 |
| STEWARTM |
19 |
session pga memory max |
133,148 |
| STEWARTM |
19 |
session pga memory |
133,148 |
| STEWARTM |
19 |
session uga memory max |
30,300 |
| STEWARTM |
19 |
session uga memory |
30,300 |
| STEWARTM |
19 |
redo size |
16,260 |
| STEWARTM |
19 |
bytes received via SQL*Net from client |
3,558 |
| STEWARTM |
19 |
bytes sent via SQL*Net to client |
2,037 |
| STEWARTM |
19 |
recursive calls |
957 |
| STEWARTM |
19 |
session logical reads |
373 |
| STEWARTM |
19 |
consistent gets |
239 |
| STEWARTM |
19 |
calls to kcmgrs |
180 |
| STEWARTM |
19 |
no work - consistent read gets |
156 |
| STEWARTM |
19 |
db block changes |
156 |
| STEWARTM |
19 |
db block gets |
145 |
| STEWARTM |
19 |
calls to get snapshot scn: kcmgss |
114 |
| STEWARTM |
19 |
redo entries |
85 |
| STEWARTM |
19 |
execute count |
83 |
| STEWARTM |
19 |
parse count |
74 |
| STEWARTM |
19 |
enqueue requests |
67 |
| STEWARTM |
19 |
enqueue releases |
66 |
| STEWARTM |
19 |
opened cursors cumulative |
60 |
| STEWARTM |
19 |
SQL*Net roundtrips to/from client |
50 |
| STEWARTM |
19 |
user calls |
47 |
| STEWARTM |
19 |
cluster key scan block gets |
44 |
| STEWARTM |
19 |
total number commit cleanout calls |
40 |
| STEWARTM |
19 |
redo small copies |
37 |
| STEWARTM |
19 |
commit cleanout number successfully completed |
36 |
| STEWARTM |
19 |
table fetch by rowid |
32 |
| STEWARTM |
19 |
free buffer requested |
25 |
| STEWARTM |
19 |
cluster key scans |
21 |
| STEWARTM |
19 |
deferred (CURRENT) block cleanout applications |
21 |
| STEWARTM |
19 |
cursor authentications |
18 |
| STEWARTM |
19 |
calls to kcmgas |
17 |
| STEWARTM |
19 |
messages sent |
13 |
| STEWARTM |
19 |
physical reads |
12 |
| STEWARTM |
19 |
data blocks consistent reads - undo records applied |
11 |
| STEWARTM |
19 |
consistent changes |
11 |
| STEWARTM |
19 |
CR blocks created |
11 |
| STEWARTM |
19 |
rollbacks only - consistent read gets |
10 |
| STEWARTM |
19 |
session cursor cache count |
8 |
| STEWARTM |
19 |
redo synch writes |
8 |
| STEWARTM |
19 |
immediate (CURRENT) block cleanout applications |
8 |
| STEWARTM |
19 |
session cursor cache hits |
7 |
| STEWARTM |
19 |
sorts (memory) |
5 |
| STEWARTM |
19 |
table scans (short tables) |
4 |
| STEWARTM |
19 |
user commits |
2 |
| STEWARTM |
19 |
calls to kcmgcs |
2 |
| STEWARTM |
19 |
table scan rows gotten |
2 |
| STEWARTM |
19 |
table scan blocks gotten |
2 |
| STEWARTM |
19 |
logons cumulative |
1 |
| STEWARTM |
19 |
sorts (rows) |
1 |
| STEWARTM |
19 |
opened cursors current |
1 |
| STEWARTM |
19 |
logons current |
1 |
| STEWARTM |
19 |
cleanouts and rollbacks - consistent read gets |
1 |
| STEWARTM |
19 |
immediate (CR) block cleanout applications |
1 |
| STEWARTM |
22 |
session pga memory max |
133,148 |
| STEWARTM |
22 |
session pga memory |
133,148 |
| STEWARTM |
22 |
session uga memory max |
28,552 |
| STEWARTM |
22 |
session uga memory |
24,312 |