Exadata Wait Events:
NAME WAIT_CLASS
---------------------------------------------------------------- --------------------------------------------------
cell list of blocks physical read User I/O
cell manager cancel work request Other
cell manager closing cell System I/O
cell manager discovering disks System I/O
cell manager opening cell System I/O
cell multiblock physical read User I/O
cell single block physical read User I/O
cell smart file creation User I/O
cell smart flash unkeep Other
cell smart incremental backup System I/O
cell smart index scan User I/O
cell smart restore from backup System I/O
cell smart table scan User I/O
cell statistics gather User I/O
cell worker idle Idle
cell worker online completion Other
cell worker retry Other
This is a blog where I describe and share my experiences as a technical expert and as a bootstrap start-up founder with over of 20+ years of professional career
Showing posts with label Database. Show all posts
Showing posts with label Database. Show all posts
Friday, November 26, 2010
tidbit:Oracle:Exadata Wait Events (cell related)
Labels:
Database,
Exadata,
Oracle,
Performance
tidbit:Oracle:Exadata System Statistics (cell related)
Exadata cell statistics:
STATISTIC# NAME CLASS
---------- ---------------------------------------------------------------- ----------
51 cell physical IO interconnect bytes 64
224 cell physical IO bytes saved during optimized file creation 64
225 cell physical IO bytes saved during optimized RMAN file restore 64
226 cell physical IO bytes eligible for predicate offload 64
227 cell physical IO bytes saved by storage index 8
228 cell smart IO session cache lookups 64
229 cell smart IO session cache hits 64
230 cell smart IO session cache soft misses 64
231 cell smart IO session cache hard misses 64
232 cell smart IO session cache hwm 64
233 cell num smart IO sessions in rdbms block IO due to user 64
234 cell num smart IO sessions in rdbms block IO due to big payload 64
235 cell num smart IO sessions using passthru mode due to user 64
236 cell num smart IO sessions using passthru mode due to cellsrv 64
237 cell num smart IO sessions using passthru mode due to timezone 64
238 cell num smart file creation sessions using rdbms block IO mode 64
239 cell physical IO interconnect bytes returned by smart scan 64
240 cell session smart scan efficiency 64
359 cell scans 64
360 cell blocks processed by cache layer 128
361 cell blocks processed by txn layer 128
362 cell blocks processed by data layer 128
363 cell blocks processed by index layer 128
364 cell commit cache queries 64
365 cell transactions found in commit cache 64
366 cell blocks helped by commit cache 64
367 cell blocks helped by minscn optimization 64
368 cell blocks skipped due to chained rows 64
369 cell simulated physical IO bytes eligible for predicate offload 192
370 cell simulated physical IO bytes returned by predicate offload 192
371 cell simulated session smart scan efficiency 192
372 cell CUs sent uncompressed 64
373 cell CUs sent compressed 64
374 cell CUs sent head piece 64
375 cell CUs processed for uncompressed 64
376 cell CUs processed for compressed 64
377 cell IO uncompressed bytes 64
394 cell index scans 64
571 cell flash cache read hits 8
STATISTIC# NAME CLASS
---------- ---------------------------------------------------------------- ----------
51 cell physical IO interconnect bytes 64
224 cell physical IO bytes saved during optimized file creation 64
225 cell physical IO bytes saved during optimized RMAN file restore 64
226 cell physical IO bytes eligible for predicate offload 64
227 cell physical IO bytes saved by storage index 8
228 cell smart IO session cache lookups 64
229 cell smart IO session cache hits 64
230 cell smart IO session cache soft misses 64
231 cell smart IO session cache hard misses 64
232 cell smart IO session cache hwm 64
233 cell num smart IO sessions in rdbms block IO due to user 64
234 cell num smart IO sessions in rdbms block IO due to big payload 64
235 cell num smart IO sessions using passthru mode due to user 64
236 cell num smart IO sessions using passthru mode due to cellsrv 64
237 cell num smart IO sessions using passthru mode due to timezone 64
238 cell num smart file creation sessions using rdbms block IO mode 64
239 cell physical IO interconnect bytes returned by smart scan 64
240 cell session smart scan efficiency 64
359 cell scans 64
360 cell blocks processed by cache layer 128
361 cell blocks processed by txn layer 128
362 cell blocks processed by data layer 128
363 cell blocks processed by index layer 128
364 cell commit cache queries 64
365 cell transactions found in commit cache 64
366 cell blocks helped by commit cache 64
367 cell blocks helped by minscn optimization 64
368 cell blocks skipped due to chained rows 64
369 cell simulated physical IO bytes eligible for predicate offload 192
370 cell simulated physical IO bytes returned by predicate offload 192
371 cell simulated session smart scan efficiency 192
372 cell CUs sent uncompressed 64
373 cell CUs sent compressed 64
374 cell CUs sent head piece 64
375 cell CUs processed for uncompressed 64
376 cell CUs processed for compressed 64
377 cell IO uncompressed bytes 64
394 cell index scans 64
571 cell flash cache read hits 8
Labels:
Database,
Exadata,
Oracle,
Performance
Subscribe to:
Posts (Atom)