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