temp2

logons cumulative 0 1
logons current 1 1
opened cursors cumulative 2 77
opened cursors current 3 49
user commits 4 10
user rollbacks 5 0
user calls 6 38
recursive calls 7 1241
recursive cpu usage 8 18075
session logical reads 9 11856579
session stored procedure space 10 0
CPU used when call started 11 22
CPU used by this session 12 18097
DB time 13 61
cluster wait time 14 0
concurrency wait time 15 80
application wait time 16 0
user I/O wait time 17 50777
session connect time 18 1219999405
process last non-idle time 19 1219999405
session uga memory 20 1793744
session uga memory max 21 7694888
messages sent 22 12
messages received 23 0
background timeouts 24 0
session pga memory 25 2395736
session pga memory max 26 8228440
enqueue timeouts 27 0
enqueue waits 28 0
enqueue deadlocks 29 0
enqueue requests 30 209
enqueue conversions 31 0
enqueue releases 32 192
global enqueue gets sync 33 0
global enqueue gets async 34 0
global enqueue get time 35 0
global enqueue releases 36 0
physical read total IO requests 37 30897
physical read total multi block requests 38 0
physical read total bytes 39 253108224
physical write total IO requests 40 0
physical write total multi block requests 41 0
physical write total bytes 42 0
IPC CPU used by this session 43 0
gcs messages sent 44 0
ges messages sent 45 0
global enqueue CPU used by this session 46 0
db block gets 47 3049
db block gets from cache 48 3049
db block gets direct 49 0
consistent gets 50 11856154
consistent gets from cache 51 11856226
consistent gets - examination 52 3236
consistent gets direct 53 0
physical reads 54 30897
physical reads cache 55 30897
physical reads direct 56 0
physical read IO requests 57 30897
physical read bytes 58 253108224
db block changes 59 4063
consistent changes 60 3400
recovery blocks read 61 0
physical writes 62 0
physical writes direct 63 0
physical writes from cache 64 0
physical write IO requests 65 0
physical write bytes 66 0
physical writes non checkpoint 67 0
summed dirty queue length 68 0
DBWR checkpoint buffers written 69 0
DBWR thread checkpoint buffers written 70 0
DBWR tablespace checkpoint buffers written 71 0
DBWR parallel query checkpoint buffers written 72 0
DBWR object drop buffers written 73 0
DBWR transaction table writes 74 0
DBWR undo block writes 75 0
DBWR revisited being-written buffer 76 0
DBWR make free requests 77 0
DBWR lru scans 78 0
DBWR checkpoints 79 0
DBWR fusion writes 80 0
prefetch clients - keep 81 0
prefetch clients - recycle 82 0
prefetch clients - default 83 0
prefetch clients - 2k 84 0
prefetch clients - 4k 85 0
prefetch clients - 8k 86 0
prefetch clients - 16k 87 0
prefetch clients - 32k 88 0
change write time 89 2
redo synch writes 90 3
redo synch time 91 2
exchange deadlocks 92 0
free buffer requested 93 31327
dirty buffers inspected 94 258
pinned buffers inspected 95 0
hot buffers moved to head of LRU 96 28072
free buffer inspected 97 32772
commit cleanout failures: write disabled 98 0
commit cleanout failures: block lost 99 13
commit cleanout failures: cannot pin 100 0
commit cleanout failures: hot backup in progress 101 0
commit cleanout failures: buffer being written 102 0
commit cleanout failures: callback failure  103 1
commit cleanouts 104 118
commit cleanouts successfully completed 105 104
recovery array reads 106 0
recovery array read time 107 0
CR blocks created 108 105
current blocks converted for CR 109 0
switch current to new buffer 110 212
write clones created in foreground 111 0
write clones created in background 112 0
write clones created for recovery 113 0
physical reads cache prefetch 114 0
physical reads prefetch warmup 115 0
prefetched blocks aged out before use 116 0
prefetch warmup blocks aged out before use 117 0
prefetch warmup blocks flushed out before use 118 0
physical reads retry corrupt 119 0
physical reads direct (lob) 120 0
physical reads direct temporary tablespace 121 0
physical writes direct (lob) 122 0
physical writes direct temporary tablespace 123 0
cold recycle reads 124 0
shared hash latch upgrades - no wait 125 8
shared hash latch upgrades - wait 126 0
physical reads for flashback new 127 0
calls to kcmgcs 128 53
calls to kcmgrs 129 0
calls to kcmgas 130 389
calls to get snapshot scn: kcmgss 131 2476
redo blocks read for recovery 132 0
redo entries 133 2039
redo size 134 748920
redo buffer allocation retries 135 0
redo wastage 136 0
redo writer latching time 137 0
redo writes 138 0
redo blocks written 139 0
redo write time 140 0
redo log space requests 141 0
redo log space wait time 142 0
redo log switch interrupts 143 0
redo ordering marks 144 50
redo subscn max counts 145 86
gc cr blocks served 146 0
gc cr block build time 147 0
gc cr block flush time 148 0
gc cr block send time 149 0
gc current blocks served 150 0
gc current block pin time 151 0
gc current block flush time 152 0
gc current block send time 153 0
gc cr blocks received 154 0
gc cr block receive time 155 0
gc current blocks received 156 0
gc current block receive time 157 0
gc local grants 158 0
gc remote grants 159 0
gc blocks lost 160 0
gc claim blocks lost 161 0
gc blocks corrupt 162 0
gc CPU used by this session 163 0
total number of slots 164 0
instance recovery database freeze count 165 0
background checkpoints started 166 0
background checkpoints completed 167 0
number of map operations 168 0
number of map misses 169 0
flashback log writes 170 0
serializable aborts 171 0
transaction lock foreground requests 172 0
transaction lock foreground wait time 173 0
transaction lock background gets 174 0
transaction lock background get time 175 0
undo change vector size 176 383356
transaction tables consistent reads - undo records applied 177 0
transaction tables consistent read rollbacks 178 0
data blocks consistent reads - undo records applied 179 2470
no work - consistent read gets 180 11860481
cleanouts only - consistent read gets 181 3
rollbacks only - consistent read gets 182 3
cleanouts and rollbacks - consistent read gets 183 99
RowCR attempts 184 0
RowCR hits 185 0
RowCR - row contention 186 0
RowCR - resume 187 0
rollback changes - undo records applied 188 0
transaction rollbacks 189 0
immediate (CURRENT) block cleanout applications 190 11
immediate (CR) block cleanout applications 191 102
deferred (CURRENT) block cleanout applications 192 60
commit txn count during cleanout 193 3
active txn count during cleanout 194 185
cleanout - number of ktugct calls 195 149
immediate CR cleanouts (index blocks) 196 0
deferred CUR cleanouts (index blocks) 197 0
Commit SCN cached 198 3
Cached Commit SCN referenced 199 214029
auto extends on undo tablespace 200 0
drop segment calls in space pressure 201 0
total number of undo segments dropped 202 0
doubling up with imu segment 203 0
tune down retentions in space pressure 204 0
steps of tune down ret. in space pressure 205 0
space was found by tune down 206 0
space was not found by tune down 207 0
commit batch/immediate requested 208 0
commit batch requested 209 0
commit immediate requested 210 0
commit batch/immediate performed 211 0
commit batch performed 212 0
commit immediate performed 213 0
commit wait/nowait requested 214 0
commit nowait requested 215 0
commit wait requested 216 0
commit wait/nowait performed 217 0
commit nowait performed 218 0
commit wait performed 219 0
global undo segment hints helped 220 0
global undo segment hints were stale 221 0
local undo segment hints helped 222 0
local undo segment hints were stale 223 0
undo segment header was pinned 224 0
total number of times SMON posted 225 0
SMON posted for undo segment recovery 226 0
SMON posted for txn recovery for other instances 227 0
SMON posted for instance recovery 228 0
SMON posted for undo segment shrink 229 0
SMON posted for dropping temp segment 230 0
SMON posted for supplemental logging cleanup 231 0
IMU commits 232 1
IMU Flushes 233 12
IMU contention 234 0
IMU recursive-transaction flush 235 0
IMU undo retention flush 236 0
IMU ktichg flush 237 6
IMU bind flushes 238 0
IMU mbu flush 239 0
IMU pool not allocated 240 0
IMU CR rollbacks 241 226
IMU undo allocation size 242 201560
IMU Redo allocation size 243 25176
IMU- failed to get a private strand 244 0
Misses for writing mapping 245 0
table scans (short tables) 246 663
table scans (long tables) 247 0
table scans (rowid ranges) 248 0
table scans (cache partitions) 249 0
table scans (direct read) 250 0
table scan rows gotten 251 11331494
table scan blocks gotten 252 187779
table fetch by rowid 253 2888496
table fetch continued row 254 0
cluster key scans 255 64
cluster key scan block gets 256 70
rows fetched via callback 257 11
queue update without cp update 258 0
index crx upgrade (prefetch) 259 0
index crx upgrade (found) 260 0
index crx upgrade (positioned) 261 4
leaf node splits 262 0
leaf node 90-10 splits 263 0
branch node splits 264 0
failed probes on index block reclamation 265 0
recursive aborts on index block reclamation 266 0
native hash arithmetic execute 267 0
native hash arithmetic fail 268 0
lob reads 269 0
lob writes 270 0
lob writes unaligned 271 0
index fast full scans (full) 272 0
index fast full scans (rowid ranges) 273 0
index fast full scans (direct read) 274 0
index fetch by key 275 1049644
index scans kdiixs1 276 993
queue splits 277 0
queue flush 278 0
queue position update 279 0
queue single row 280 0
queue ocp pages 281 0
queue qno pages 282 0
heap block compress 283 85
sql area purged 284 0
sql area evicted 285 0
CCursor + sql area evicted 286 0
session cursor cache hits 287 11
session cursor cache count 288 17
java call heap total size 289 0
java call heap total size max 290 0
java call heap used size 291 0
java call heap used size max 292 0
java call heap live size 293 0
java call heap live size max 294 0
java call heap object count 295 0
java call heap object count max 296 0
java call heap live object count 297 0
java call heap live object count max 298 0
java call heap gc count 299 0
java call heap collected count 300 0
java call heap collected bytes 301 0
java session heap used size 302 0
java session heap used size max 303 0
java session heap live size 304 0
java session heap live size max 305 0
java session heap object count 306 0
java session heap object count max 307 0
java session heap live object count 308 0
java session heap live object count max 309 0
java session heap gc count 310 0
java session heap collected count 311 0
java session heap collected bytes 312 0
cursor authentications 313 0
queries parallelized 314 0
DML statements parallelized 315 0
DDL statements parallelized 316 0
DFO trees parallelized 317 0
Parallel operations not downgraded 318 0
Parallel operations downgraded to serial 319 0
Parallel operations downgraded 75 to 99 pct 320 0
Parallel operations downgraded 50 to 75 pct 321 0
Parallel operations downgraded 25 to 50 pct 322 0
Parallel operations downgraded 1 to 25 pct 323 0
PX local messages sent 324 0
PX local messages recv'd 325 0
PX remote messages sent 326 0
PX remote messages recv'd 327 0
buffer is pinned count 328 6651614
buffer is not pinned count 329 177777
no buffer to keep pinned count 330 0
table lookup prefetch client count 331 0
workarea memory allocated 332 0
workarea executions - optimal 333 60
workarea executions - onepass 334 0
workarea executions - multipass 335 0
parse time cpu 336 0
parse time elapsed 337 0
parse count (total) 338 77
parse count (hard) 339 0
parse count (failures) 340 0
frame. signature mismatch 341 0
execute count 342 688
bytes sent via SQL*Net to client 343 4297
bytes received via SQL*Net from client 344 3946
SQL*Net roundtrips to/from client 345 28
bytes sent via SQL*Net to dblink 346 0
bytes received via SQL*Net from dblink 347 0
SQL*Net roundtrips to/from dblink 348 0
sorts (memory) 349 69
sorts (disk) 350 0
sorts (rows) 351 16482
OTC commit optimization attempts 352 0
OTC commit optimization hits 353 0
OTC commit optimization failure - setup 354 0
OS User time used 355 0
OS System time used 356 0
OS Maximum resident set size 357 0
OS Integral shared text size 358 0
OS Integral unshared data size 359 0
OS Integral unshared stack size 360 0
OS Page reclaims 361 0
OS Page faults 362 0
OS Swaps 363 0
OS Block input operations 364 0
OS Block output operations 365 0
OS Socket messages sent 366 0
OS Socket messages received 367 0
OS Signals received 368 0
OS Voluntary context switches 369 0
OS Involuntary context switches 370 0

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11079750/viewspace-438954/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/11079750/viewspace-438954/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值