Facebook
From Bitty Octupus, 4 Years ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 174
  1. buffer is not pinned count      60008
  2. bytes received via SQL*Net from client  1239
  3. bytes sent via SQL*Net to client        21431
  4. calls to get snapshot scn: kcmgss       15
  5. calls to kcmgas 2
  6. cluster key scan block gets     120000
  7. cluster key scans       60000
  8. consistent gets 120167
  9. consistent gets from cache      120167
  10. CPU used by this session        124
  11. CPU used when call started      123
  12. cursor authentications  1
  13. DB time 140
  14. dirty buffers inspected 1184
  15. enqueue releases        16
  16. enqueue requests        16
  17. execute count   6
  18. free buffer inspected   4938
  19. free buffer requested   4774
  20. hot buffers moved to head of LRU        1418
  21. index fast full scans (full)    1
  22. messages sent   4
  23. no work - consistent read gets  120158
  24. opened cursors cumulative       6
  25. OS Involuntary context switches 244
  26. OS Maximum resident set size    45244
  27. OS Page reclaims        11426
  28. OS System time used     79
  29. OS User time used       44
  30. OS Voluntary context switches   95
  31. parse count (hard)      2
  32. parse count (total)     6
  33. parse time cpu  1
  34. parse time elapsed      1
  35. physical read bytes     39108608
  36. physical read IO requests       4640
  37. physical read total bytes       39108608
  38. physical read total IO requests 4640
  39. physical read total multi block requests        20
  40. physical reads  4774
  41. physical reads cache    4774
  42. physical reads cache prefetch   134
  43. physical write bytes    3211264
  44. physical write IO requests      56
  45. physical write total bytes      3211264
  46. physical write total IO requests        56
  47. physical write total multi block requests       56
  48. physical writes 392
  49. physical writes direct  392
  50. physical writes direct temporary tablespace     392
  51. physical writes non checkpoint  392
  52. recursive calls 20
  53. recursive cpu usage     2
  54. session logical reads   120167
  55. session pga memory      114044
  56. session pga memory max  2228224
  57. session uga memory      65572
  58. sorts (memory)  5
  59. sorts (rows)    796
  60. SQL*Net roundtrips to/from client       20
  61. table fetch by rowid    4
  62. table scan blocks gotten        20
  63. table scan rows gotten  3000
  64. table scans (short tables)      1
  65. user calls      19
  66. user I/O wait time      8
  67. workarea executions - onepass   1
  68. workarea executions - optimal   4