Database Up Info
warning
alert
Level Statistic Value
CPU used by this session 721
CPU used when call started 560
CR blocks created 2
Cached Commit SCN referenced 0
Commit SCN cached 0
DB time 39594
DBWR checkpoint buffers written 275
DBWR checkpoints 1
DBWR fusion writes 0
DBWR lru scans 0
DBWR make free requests 0
DBWR object drop buffers written 0
DBWR parallel query checkpoint buffers written 0
DBWR revisited being-written buffer 0
DBWR tablespace checkpoint buffers written 0
DBWR thread checkpoint buffers written 275
DBWR transaction table writes 22
DBWR undo block writes 78
DDL statements parallelized 0
DFO trees parallelized 0
DML statements parallelized 0
IMU CR rollbacks 0
IMU Flushes 3
IMU Redo allocation size 6564
IMU bind flushes 0
IMU commits 14
IMU contention 0
IMU ktichg flush 0
IMU mbu flush 0
IMU pool not allocated 0
IMU recursive-transaction flush 0
IMU undo allocation size 57236
IMU undo retention flush 0
IMU- failed to get a private strand 0
IPC CPU used by this session 0
Misses for writing mapping 0
OS Block input operations 0
OS Block output operations 0
OS Integral shared text size 0
OS Integral unshared data size 0
OS Integral unshared stack size 0
OS Involuntary context switches 0
OS Maximum resident set size 0
OS Page faults 0
OS Page reclaims 0
OS Signals received 0
OS Socket messages received 0
OS Socket messages sent 0
OS Swaps 0
OS System time used 0
OS User time used 0
OS Voluntary context switches 0
OTC commit optimization attempts 0
OTC commit optimization failure - setup 0
OTC commit optimization hits 0
PX local messages recv'd 0
PX local messages sent 0
PX remote messages recv'd 0
PX remote messages sent 0
Parallel operations downgraded 1 to 25 pct 0
Parallel operations downgraded 25 to 50 pct 0
Parallel operations downgraded 50 to 75 pct 0
Parallel operations downgraded 75 to 99 pct 0
Parallel operations downgraded to serial 0
Parallel operations not downgraded 0
RowCR - resume 0
RowCR - row contention 0
RowCR attempts 0
RowCR hits 0
SMON posted for dropping temp segment 0
SMON posted for instance recovery 0
SMON posted for supplemental logging cleanup 0
SMON posted for txn recovery for other instances 0
SMON posted for undo segment recovery 0
SMON posted for undo segment shrink 0
SQL*Net roundtrips to/from client 365
SQL*Net roundtrips to/from dblink 0
active txn count during cleanout 17
application wait time 0
auto extends on undo tablespace 0
background checkpoints completed 0
background checkpoints started 0
background timeouts 10053
branch node splits 0
buffer is not pinned count 33386
buffer is pinned count 97762
bytes received via SQL*Net from client 52962
bytes received via SQL*Net from dblink 0
bytes sent via SQL*Net to client 594944
bytes sent via SQL*Net to dblink 0
calls to get snapshot scn: kcmgss 17065
calls to kcmgas 341
calls to kcmgcs 27
calls to kcmgrs 0
change write time 28
cleanout - number of ktugct calls 46
cleanouts and rollbacks - consistent read gets 0
cleanouts only - consistent read gets 8
cluster key scan block gets 8118
cluster key scans 3225
cluster wait time 0
cold recycle reads 0
commit batch performed 0
commit batch requested 0
commit batch/immediate performed 0
commit batch/immediate requested 0
commit cleanout failures: block lost 0
commit cleanout failures: buffer being written 0
commit cleanout failures: callback failure 2
commit cleanout failures: cannot pin 0
commit cleanout failures: hot backup in progress 0
commit cleanout failures: write disabled 0
commit cleanouts 522
commit cleanouts successfully completed 520
commit immediate performed 0
commit immediate requested 0
commit nowait performed 0
commit nowait requested 0
commit txn count during cleanout 39
commit wait performed 0
commit wait requested 0
commit wait/nowait performed 0
commit wait/nowait requested 0
concurrency wait time 242
consistent changes 2
consistent gets 85160
consistent gets - examination 25064
consistent gets direct 0
consistent gets from cache 85160
current blocks converted for CR 0
cursor authentications 197
data blocks consistent reads - undo records applied 2
db block changes 2797
db block gets 2692
db block gets direct 0
db block gets from cache 2692
deferred (CURRENT) block cleanout applications 307
deferred CUR cleanouts (index blocks) 0
dirty buffers inspected 0
doubling up with imu segment 0
drop segment calls in space pressure 0
enqueue conversions 654
enqueue deadlocks 0
enqueue releases 27186
enqueue requests 27199
enqueue timeouts 0
enqueue waits 0
exchange deadlocks 0
execute count 12056
flashback log writes 0
frame signature mismatch 0
free buffer inspected 0
free buffer requested 5144
gc CPU used by this session 0
gc blocks corrupt 0
gc blocks lost 0
gc claim blocks lost 0
gc cr block build time 0
gc cr block flush time 0
gc cr block receive time 0
gc cr block send time 0
gc cr blocks received 0
gc cr blocks served 0
gc current block flush time 0
gc current block pin time 0
gc current block receive time 0
gc current block send time 0
gc current blocks received 0
gc current blocks served 0
gcs messages sent 0
ges messages sent 0
global enqueue CPU used by this session 0
global enqueue get time 0
global enqueue gets async 0
global enqueue gets sync 0
global enqueue releases 0
global undo segment hints helped 0
global undo segment hints were stale 0
heap block compress 6
hot buffers moved to head of LRU 0
immediate (CR) block cleanout applications 8
immediate (CURRENT) block cleanout applications 44
immediate CR cleanouts (index blocks) 0
index fast full scans (direct read) 0
index fast full scans (full) 0
index fast full scans (rowid ranges) 0
index fetch by key 44428
index scans kdiixs1 5834
instance recovery database freeze count 0
java call heap collected bytes 0
java call heap collected count 0
java call heap gc count 0
java call heap live object count 0
java call heap live object count max 0
java call heap live size 0
java call heap live size max 0
java call heap object count 0
java call heap object count max 0
java call heap total size 0
java call heap total size max 0
java call heap used size 0
java call heap used size max 0
java session heap collected bytes 0
java session heap collected count 0
java session heap gc count 0
java session heap live object count 0
java session heap live object count max 0
java session heap live size 0
java session heap live size max 0
java session heap object count 0
java session heap object count max 0
java session heap used size 0
java session heap used size max 0
leaf node 90-10 splits 6
leaf node splits 8
lob reads 470
lob writes 0
lob writes unaligned 0
local undo segment hints helped 0
local undo segment hints were stale 0
logons cumulative 33
logons current 15
messages received 253
messages sent 249
native hash arithmetic execute 0
native hash arithmetic fail 0
no buffer to keep pinned count 1
no work - consistent read gets 51265
number of map misses 0
number of map operations 0
opened cursors cumulative 9832
opened cursors current 34
parse count (failures) 0
parse count (hard) 764
parse count (total) 4843
parse time cpu 207
parse time elapsed 1180
physical read IO requests 3738
physical read bytes 40583168
physical read total IO requests 5155
physical read total bytes 76260864
physical read total multi block requests 207
physical reads 4954
physical reads cache 4934
physical reads cache prefetch 1216
physical reads direct 20
physical reads direct (lob) 0
physical reads direct temporary tablespace 4
physical reads for flashback new 0
physical reads prefetch warmup 423
physical reads retry corrupt 0
physical write IO requests 251
physical write bytes 2752512
physical write total IO requests 1615
physical write total bytes 21818880
physical write total multi block requests 253
physical writes 336
physical writes direct 8
physical writes direct (lob) 0
physical writes direct temporary tablespace 0
physical writes from cache 328
physical writes non checkpoint 336
pinned buffers inspected 0
prefetch clients - 16k 0
prefetch clients - 2k 0
prefetch clients - 32k 0
prefetch clients - 4k 0
prefetch clients - 8k 0
prefetch clients - default 0
prefetch clients - keep 0
prefetch clients - recycle 0
prefetch warmup blocks aged out before use 0
prefetch warmup blocks flushed out before use 0
prefetched blocks aged out before use 0
process last non-idle time 1162676133
queries parallelized 0
queue flush 0
queue ocp pages 0
queue position update 0
queue qno pages 0
queue single row 0
queue splits 0
queue update without cp update 0
recovery array read time 0
recovery array reads 0
recovery blocks read 53
recursive calls 155510
recursive cpu usage 436
redo blocks read for recovery 196
redo blocks written 1599
redo buffer allocation retries 0
redo entries 1428
redo log space requests 0
redo log space wait time 0
redo log switch interrupts 0
redo ordering marks 0
redo size 732412
redo subscn max counts 0
redo synch time 14
redo synch writes 48
redo wastage 60100
redo write time 201
redo writer latching time 0
redo writes 214
rollback changes - undo records applied 6
rollbacks only - consistent read gets 2
rows fetched via callback 4560
serializable aborts 0
session connect time 1162676133
session cursor cache count 260
session cursor cache hits 8369
session logical reads 87852
session pga memory 25307572
session pga memory max 32516532
session stored procedure space 0
session uga memory 25773322288
session uga memory max 14764980
shared hash latch upgrades - no wait 6277
shared hash latch upgrades - wait 0
sorts (disk) 0
sorts (memory) 4264
sorts (rows) 49415
space was found by tune down 0
space was not found by tune down 0
sql area aged 0
sql area purged 21
steps of tune down ret. in space pressure 0
summed dirty queue length 0
switch current to new buffer 3
table fetch by rowid 26161
table fetch continued row 226
table lookup prefetch client count 0
table scan blocks gotten 33408
table scan rows gotten 734071
table scans (cache partitions) 0
table scans (direct read) 0
table scans (long tables) 4
table scans (rowid ranges) 0
table scans (short tables) 1231
total number of slots 0
total number of times SMON posted 6
total number of undo segments dropped 0
transaction lock background get time 0
transaction lock background gets 0
transaction lock foreground requests 0
transaction lock foreground wait time 0
transaction rollbacks 0
transaction tables consistent read rollbacks 0
transaction tables consistent reads - undo records applied 0
tune down retentions in space pressure 0
undo change vector size 243696
undo segment header was pinned 0
user I/O wait time 2220
user calls 580
user commits 17
user rollbacks 0
workarea executions - multipass 0
workarea executions - onepass 0
workarea executions - optimal 2092
workarea memory allocated 0
write clones created for recovery 0
write clones created in background 0
write clones created in foreground 0
Info for XE Database last updated 11/04/2006 15:51