| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> DBAs - your expert opinions
What conclusions, if any, would you draw from the following -
NAME GETS MISSES
-------------------------------------------------- ---------- ----------
IMMEDIATE_GETS IMMEDIATE_MISSES
-------------- ----------------
latch wait list 13210344 36418
0 0
process allocation 48509 25
0 0
session allocation 37809794 6249
0 0
session switching 67991 0
0 0
session idle bit 340618397 401759
2 0
messages 53931245 36584
0 0
enqueues 69327497 47435
0 0
trace latch 0 0
0 0
cache buffers chains -1.163E+09 2843934
382305059 271828
cache buffers lru chain 239071810 13086536
969254285 473353608
cache buffer handles 24142972 1911
0 0
multiblock read objects 13420843 668
0 0
cache protection latch 0 0
0 0
system commit number 205371676 58775
0 0
archive control 104 0
0 0
redo allocation 69540867 174924
0 0
redo copy 0 0
0 0
instance latch 0 0
0 0
lock element parent latch 0 0
0 0
dml lock allocation 27840629 2081
0 0
transaction allocation 23872279 2873
0 0
undo global data 53568515 18944
0 0
sequence cache 914237 12
0 0
sequence cache entry 0 0
0 0
row cache objects 97264552 78346
108240 440
cost function 1 0
0 0
user lock 116294 20
0 0
global transaction mapping table 2879181 65
21 0
global transaction 60731661 0
0 0
shared pool 38301300 170745
0 0
library cache 465602713 2162159
4278425 26942
library cache pin 494884694 4905327
260915 8002
library cache load lock 401373 143
0 0
virtual circuit buffers 0 0
0 0
virtual circuit queues 0 0
0 0
virtual circuits 0 0
0 0
query server process 307 1
297 0
query server freelists 3940 83
0 0
error message lists 678 9
0 0
process queue 3082 0
0 0
process queue reference 773241 18
156590 53
parallel query stats 276 0
0 0
Received on Mon Jul 28 1997 - 00:00:00 CDT
 |
 |