-
Notifications
You must be signed in to change notification settings - Fork 24
/
class_name.sql
665 lines (663 loc) · 27.1 KB
/
class_name.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
--
-- Show statistic names per class
--
break on class_name
column class_name format a10
select
decode(class,
1, 'User',
2, 'Redo',
4, 'Enqueue',
8, 'Cache',
16, 'OS',
32, 'RAC',
64, 'SQL',
128, 'Debug',
192, 'SQL+Debug',
'?: ' || class ) class_name,
----------------------------
name
from
v$statname
order by
class,
lower(name);
--
-- User application wait time
-- bytes received via SQL*Net from client
-- bytes received via SQL*Net from dblink
-- bytes sent via SQL*Net to client
-- bytes sent via SQL*Net to dblink
-- bytes via SQL*Net vector from client
-- bytes via SQL*Net vector from dblink
-- bytes via SQL*Net vector to client
-- bytes via SQL*Net vector to dblink
-- cluster wait time
-- commit batch performed
-- commit batch requested
-- commit batch/immediate performed
-- commit batch/immediate requested
-- commit immediate performed
-- commit immediate requested
-- commit nowait performed
-- commit nowait requested
-- commit wait performed
-- commit wait requested
-- commit wait/nowait performed
-- commit wait/nowait requested
-- concurrency wait time
-- CPU used by this session
-- DB time
-- file io service time
-- file io wait time
-- in call idle wait time
-- java call heap collected bytes
-- java call heap collected count
-- java call heap gc count
-- java call heap live object count
-- java call heap live object count max
-- java call heap live size
-- java call heap live size max
-- java call heap object count
-- java call heap object count max
-- java call heap total size
-- java call heap total size max
-- java call heap used size
-- java call heap used size max
-- java session heap collected bytes
-- java session heap collected count
-- java session heap gc count
-- java session heap live object count
-- java session heap live object count max
-- java session heap live size
-- java session heap live size max
-- java session heap object count
-- java session heap object count max
-- java session heap used size
-- java session heap used size max
-- logons cumulative
-- logons current
-- No. of Decrypt ops
-- No. of Encrypt ops
-- No. of Namespaces Created
-- No. of Principal Cache Misses
-- No. of Principal Invalidations
-- No. of Roles Enabled or Disabled
-- No. of User Callbacks Executed
-- No. of XS Sessions Attached
-- No. of XS Sessions Created
-- non-idle wait count
-- non-idle wait time
-- opened cursors cumulative
-- opened cursors current
-- OS CPU Qt wait time
-- pinned cursors current
-- read-only violation count
-- recursive calls
-- recursive cpu usage
-- Requests to/from client
-- scheduler wait time
-- serializable aborts
-- session connect time
-- session logical reads
-- session logical reads in local numa group
-- session logical reads in remote numa group
-- session pga memory
-- session pga memory max
-- session stored procedure space
-- session uga memory
-- session uga memory max
-- SQL*Net roundtrips to/from client
-- SQL*Net roundtrips to/from dblink
-- temp space allocated (bytes)
-- user calls
-- user commits
-- user I/O wait time
-- user rollbacks
-- Workload Capture: dbtime
-- Workload Capture: errors
-- Workload Capture: size (in bytes) of recording
-- Workload Capture: unreplayable user calls
-- Workload Capture: unsupported user calls
-- Workload Capture: user calls
-- Workload Capture: user calls flushed
-- Workload Capture: user logins
-- Workload Capture: user txns
-- Workload Replay: dbtime
-- Workload Replay: deadlocks resolved
-- Workload Replay: network time
-- Workload Replay: think time
-- Workload Replay: time gain
-- Workload Replay: time loss
-- Workload Replay: user calls
-- Redo flashback log write bytes
-- flashback log writes
-- redo blocks checksummed by FG (exclusive)
-- redo blocks checksummed by LGWR
-- redo blocks read for recovery
-- redo blocks written
-- redo buffer allocation retries
-- redo entries
-- redo entries for lost write detection
-- redo k-bytes read for recovery
-- redo k-bytes read for terminal recovery
-- redo KB read
-- redo KB read (memory)
-- redo KB read (memory) for transport
-- redo KB read for transport
-- redo log space requests
-- redo log space wait time
-- redo ordering marks
-- redo size
-- redo size for direct writes
-- redo size for lost write detection
-- redo subscn max counts
-- redo synch poll writes
-- redo synch polls
-- redo synch time
-- redo synch writes
-- redo wastage
-- redo write broadcast ack count
-- redo write broadcast ack time
-- redo write broadcast lgwr post count
-- redo write time
-- redo writes
-- Enqueue enqueue conversions
-- enqueue deadlocks
-- enqueue releases
-- enqueue requests
-- enqueue timeouts
-- enqueue waits
-- max cf enq hold time
-- total cf enq hold time
-- total number of cf enq holders
-- Cache background checkpoints completed
-- background checkpoints started
-- blocks decrypted
-- blocks encrypted
-- cell flash cache read hits
-- cell physical IO bytes saved by storage index
-- change write time
-- checkpoint clones created for ADG recovery
-- cold recycle reads
-- commit cleanout failures: block lost
-- commit cleanout failures: buffer being written
-- commit cleanout failures: callback failure
-- commit cleanout failures: cannot pin
-- commit cleanout failures: hot backup in progress
-- commit cleanout failures: write disabled
-- commit cleanouts
-- commit cleanouts successfully completed
-- consistent changes
-- consistent gets
-- consistent gets - examination
-- consistent gets direct
-- consistent gets from cache
-- consistent gets from cache (fastpath)
-- CR blocks created
-- current blocks converted for CR
-- db block changes
-- db block gets
-- db block gets direct
-- db block gets from cache
-- db block gets from cache (fastpath)
-- db corrupt blocks detected
-- db corrupt blocks recovered
-- DBWR checkpoint buffers written
-- DBWR checkpoints
-- DBWR lru scans
-- DBWR object drop buffers written
-- DBWR parallel query checkpoint buffers written
-- DBWR revisited being-written buffer
-- DBWR tablespace checkpoint buffers written
-- DBWR thread checkpoint buffers written
-- DBWR transaction table writes
-- DBWR undo block writes
-- dirty buffers inspected
-- Effective IO time
-- exchange deadlocks
-- flash cache eviction: aged out
-- flash cache eviction: buffer pinned
-- flash cache eviction: invalidated
-- flash cache insert skip: corrupt
-- flash cache insert skip: DBWR overloaded
-- flash cache insert skip: exists
-- flash cache insert skip: modification
-- flash cache insert skip: not current
-- flash cache insert skip: not useful
-- flash cache inserts
-- flashback cache read optimizations for block new
-- flashback direct read optimizations for block new
-- free buffer inspected
-- free buffer requested
-- hot buffers moved to head of LRU
-- lob reads
-- lob writes
-- lob writes unaligned
-- logical read bytes from cache
-- number of map misses
-- number of map operations
-- Number of read IOs issued
-- physical read bytes
-- physical read flash cache hits
-- physical read IO requests
-- physical read requests optimized
-- physical read total bytes
-- physical read total bytes optimized
-- physical read total IO requests
-- physical read total multi block requests
-- physical reads
-- physical reads cache
-- physical reads cache prefetch
-- physical reads direct
-- physical reads direct (lob)
-- physical reads direct temporary tablespace
-- physical reads for flashback new
-- physical reads prefetch warmup
-- physical reads retry corrupt
-- physical write bytes
-- physical write IO requests
-- physical write total bytes
-- physical write total IO requests
-- physical write total multi block requests
-- physical writes
-- physical writes direct
-- physical writes direct (lob)
-- physical writes direct temporary tablespace
-- physical writes from cache
-- physical writes non checkpoint
-- pinned buffers inspected
-- prefetch clients - 16k
-- prefetch clients - 2k
-- prefetch clients - 32k
-- prefetch clients - 4k
-- prefetch clients - 8k
-- prefetch clients - default
-- prefetch clients - keep
-- prefetch clients - recycle
-- prefetch warmup blocks aged out before use
-- prefetch warmup blocks flushed out before use
-- prefetched blocks aged out before use
-- recovery array read time
-- recovery array reads
-- recovery block gets from cache
-- recovery blocks read
-- recovery blocks read for lost write detection
-- recovery blocks skipped lost write checks
-- shared hash latch upgrades - no wait
-- shared hash latch upgrades - wait
-- summed dirty queue length
-- switch current to new buffer
-- total number of slots
-- write clones created for recovery
-- write clones created in background
-- write clones created in foreground
-- OS OS Block input operations
-- OS Block output operations
-- OS Integral shared text size
-- OS Integral unshared data size
-- OS Integral unshared stack size
-- OS Involuntary context switches
-- OS Maximum resident set size
-- OS Page faults
-- OS Page reclaims
-- OS Signals received
-- OS Socket messages received
-- OS Socket messages sent
-- OS Swaps
-- OS System time used
-- OS User time used
-- OS Voluntary context switches
-- RAC calls to get snapshot scn: kcmgss
-- DDL statements parallelized
-- DFO trees parallelized
-- DML statements parallelized
-- gcs messages sent
-- ges messages sent
-- global enqueue CPU used by this session
-- global enqueue get time
-- global enqueue gets async
-- global enqueue gets sync
-- global enqueue releases
-- GTX processes spawned by autotune
-- GTX processes stopped by autotune
-- IPC CPU used by this session
-- Parallel operations downgraded 1 to 25 pct
-- Parallel operations downgraded 25 to 50 pct
-- Parallel operations downgraded 50 to 75 pct
-- Parallel operations downgraded 75 to 99 pct
-- Parallel operations downgraded to serial
-- Parallel operations not downgraded
-- PX local messages recv'd
-- PX local messages sent
-- PX remote messages recv'd
-- PX remote messages sent
-- queries parallelized
-- ?: 33 Clusterwide global transactions
-- Clusterwide global transactions spanning RAC nodes
-- Forwarded 2PC commands across RAC nodes
-- ?: 40 DBWR fusion writes
-- gc blocks compressed
-- gc blocks corrupt
-- gc blocks lost
-- gc claim blocks lost
-- gc CPU used by this session
-- gc cr block build time
-- gc cr block flush time
-- gc cr block receive time
-- gc cr block send time
-- gc cr blocks received
-- gc cr blocks served
-- gc current block flush time
-- gc current block pin time
-- gc current block receive time
-- gc current block send time
-- gc current blocks received
-- gc current blocks served
-- gc kbytes saved
-- gc kbytes sent
-- gc local grants
-- gc read wait failures
-- gc read wait time
-- gc read wait timeouts
-- gc read waits
-- gc reader bypass grants
-- gc remote grants
-- SQL CCursor + sql area evicted
-- cell blocks helped by commit cache
-- cell blocks helped by minscn optimization
-- cell commit cache queries
-- cell CUs processed for compressed
-- cell CUs processed for uncompressed
-- cell CUs sent compressed
-- cell CUs sent head piece
-- cell CUs sent uncompressed
-- cell index scans
-- cell IO uncompressed bytes
-- cell num fast response sessions
-- cell num fast response sessions continuing to smart scan
-- cell num smart file creation sessions using rdbms block IO mode
-- cell num smart IO sessions in rdbms block IO due to big payload
-- cell num smart IO sessions in rdbms block IO due to no cell mem
-- cell num smart IO sessions in rdbms block IO due to user
-- cell num smart IO sessions using passthru mode due to cellsrv
-- cell num smart IO sessions using passthru mode due to timezone
-- cell num smart IO sessions using passthru mode due to user
-- cell physical IO bytes eligible for predicate offload
-- cell physical IO bytes saved during optimized file creation
-- cell physical IO bytes saved during optimized RMAN file restore
-- cell physical IO bytes sent directly to DB node to balance CPU
-- cell physical IO interconnect bytes
-- cell physical IO interconnect bytes returned by smart scan
-- cell scans
-- cell smart IO session cache hard misses
-- cell smart IO session cache hits
-- cell smart IO session cache hwm
-- cell smart IO session cache lookups
-- cell smart IO session cache soft misses
-- cell statistics spare1
-- cell statistics spare2
-- cell statistics spare3
-- cell statistics spare4
-- cell statistics spare5
-- cell statistics spare6
-- cell transactions found in commit cache
-- chained rows processed by cell
-- chained rows rejected by cell
-- chained rows skipped by cell
-- cluster key scan block gets
-- cluster key scans
-- execute count
-- frame signature mismatch
-- HCC Conventional DMLs
-- HCC non-CU Compressed Blocks
-- HCC: Number of times tried to non-CU Compress a Block
-- heap block compress
-- Heap Segment Array Inserts
-- Heap Segment Array Updates
-- HSC Compressed Segment Block Changes
-- HSC Heap Segment Block Changes
-- HSC IDL Compressed Blocks
-- HSC OLTP Compressed Blocks
-- HSC OLTP Non Compressible Blocks
-- HSC OLTP Space Saving
-- index crx upgrade (found)
-- index crx upgrade (positioned)
-- index crx upgrade (prefetch)
-- index fast full scans (direct read)
-- index fast full scans (full)
-- index fast full scans (rowid ranges)
-- native hash arithmetic execute
-- native hash arithmetic fail
-- parse count (describe)
-- parse count (failures)
-- parse count (hard)
-- parse count (total)
-- parse time cpu
-- parse time elapsed
-- rows fetched via callback
-- session cursor cache count
-- session cursor cache hits
-- sorts (disk)
-- sorts (memory)
-- sorts (rows)
-- sql area evicted
-- sql area purged
-- table fetch by rowid
-- table fetch continued row
-- table scan blocks gotten
-- table scan rows gotten
-- table scans (cache partitions)
-- table scans (direct read)
-- table scans (long tables)
-- table scans (rowid ranges)
-- table scans (short tables)
-- workarea executions - multipass
-- workarea executions - onepass
-- workarea executions - optimal
-- workarea memory allocated
-- ?: 72 Batched IO (bound) vector count
-- Batched IO (full) vector count
-- Batched IO (space) vector count
-- Batched IO block miss count
-- Batched IO buffer defrag count
-- Batched IO double miss count
-- Batched IO same unit count
-- Batched IO single block count
-- Batched IO slow jump count
-- Batched IO vector block count
-- Batched IO vector read count
-- Batched IO zero block count
-- buffer is not pinned count
-- buffer is pinned count
-- no buffer to keep pinned count
-- Debug active txn count during cleanout
-- auto extends on undo tablespace
-- background timeouts
-- Block Cleanout Optim referenced
-- branch node splits
-- Cached Commit SCN referenced
-- calls to kcmgas
-- calls to kcmgcs
-- calls to kcmgrs
-- cell blocks processed by cache layer
-- cell blocks processed by data layer
-- cell blocks processed by index layer
-- cell blocks processed by txn layer
-- cleanout - number of ktugct calls
-- cleanouts and rollbacks - consistent read gets
-- cleanouts only - consistent read gets
-- Commit SCN cached
-- commit txn count during cleanout
-- CPU used when call started
-- cursor authentications
-- data blocks consistent reads - undo records applied
-- deferred (CURRENT) block cleanout applications
-- deferred CUR cleanouts (index blocks)
-- doubling up with imu segment
-- drop segment calls in space pressure
-- DX/BB enqueue lock background get time
-- DX/BB enqueue lock background gets
-- DX/BB enqueue lock foreground requests
-- DX/BB enqueue lock foreground wait time
-- EHCC Analyze CUs Decompressed
-- EHCC Analyzer Calls
-- EHCC Archive CUs Compressed
-- EHCC Archive CUs Decompressed
-- EHCC Check CUs Decompressed
-- EHCC Columns Decompressed
-- EHCC Compressed Length Compressed
-- EHCC Compressed Length Decompressed
-- EHCC CU Row Pieces Compressed
-- EHCC CUs Compressed
-- EHCC CUs Decompressed
-- EHCC Decompressed Length Compressed
-- EHCC Decompressed Length Decompressed
-- EHCC DML CUs Decompressed
-- EHCC Dump CUs Decompressed
-- EHCC Normal Scan CUs Decompressed
-- EHCC Pieces Buffered for Decompression
-- EHCC Query High CUs Compressed
-- EHCC Query High CUs Decompressed
-- EHCC Query Low CUs Compressed
-- EHCC Query Low CUs Decompressed
-- EHCC Rowid CUs Decompressed
-- EHCC Rows Compressed
-- EHCC Rows Not Compressed
-- EHCC Total Columns for Decompression
-- EHCC Total Pieces for Decompression
-- EHCC Total Rows for Decompression
-- EHCC Turbo Scan CUs Decompressed
-- failed probes on index block reclamation
-- global undo segment hints helped
-- global undo segment hints were stale
-- HSC OLTP compression block checked
-- HSC OLTP Compression skipped rows
-- HSC OLTP Drop Column
-- HSC OLTP inline compression
-- HSC OLTP negative compression
-- HSC OLTP positive compression
-- HSC OLTP recursive compression
-- immediate (CR) block cleanout applications
-- immediate (CURRENT) block cleanout applications
-- immediate CR cleanouts (index blocks)
-- IMU bind flushes
-- IMU commits
-- IMU contention
-- IMU CR rollbacks
-- IMU Flushes
-- IMU ktichg flush
-- IMU mbu flush
-- IMU pool not allocated
-- IMU recursive-transaction flush
-- IMU Redo allocation size
-- IMU undo allocation size
-- IMU undo retention flush
-- IMU- failed to get a private strand
-- index fetch by key
-- index reclamation/extension switch
-- index scans kdiixs1
-- leaf node 90-10 splits
-- leaf node splits
-- LOB table id lookup cache misses
-- local undo segment hints helped
-- local undo segment hints were stale
-- messages received
-- messages sent
-- min active SCN optimization applied on CR
-- Misses for writing mapping
-- no work - consistent read gets
-- OTC commit optimization attempts
-- OTC commit optimization failure - setup
-- OTC commit optimization hits
-- process last non-idle time
-- queue flush
-- queue ocp pages
-- queue position update
-- queue qno pages
-- queue single row
-- queue splits
-- queue update without cp update
-- recursive aborts on index block reclamation
-- recursive system API invocations
-- redo synch long waits
-- redo synch time (usec)
-- remote Oradebug requests
-- rollback changes - undo records applied
-- rollbacks only - consistent read gets
-- root node splits
-- RowCR - resume
-- RowCR - row contention
-- RowCR attempts
-- RowCR hits
-- securefile add dedupd lob to set
-- securefile allocation bytes
-- securefile allocation chunks
-- securefile bytes cleartext
-- securefile bytes deduplicated
-- securefile bytes encrypted
-- securefile bytes non-transformed
-- securefile compressed bytes
-- securefile create dedup set
-- securefile dedup callback oper final
-- securefile dedup fits inline
-- securefile dedup flush too low
-- securefile dedup hash collision
-- securefile dedup prefix hash match
-- securefile dedup wapp cache miss
-- securefile destroy dedup set
-- securefile direct read bytes
-- securefile direct read ops
-- securefile direct write bytes
-- securefile direct write ops
-- securefile inode ioreap time
-- securefile inode read time
-- securefile inode write time
-- securefile number of flushes
-- securefile number of non-transformed flushes
-- securefile reject deduplication
-- securefile rmv from dedup set
-- securefile uncompressed bytes
-- segment cfs allocations
-- segment chunks allocation from disepnser
-- segment dispenser allocations
-- segment dispenser load empty
-- segment dispenser load tasks
-- segment prealloc bytes
-- segment prealloc ops
-- segment prealloc tasks
-- segment prealloc time (ms)
-- segment prealloc ufs2cfs bytes
-- segment total chunk allocation
-- shared io pool buffer get failure
-- shared io pool buffer get success
-- SMON posted for dropping temp segment
-- SMON posted for instance recovery
-- SMON posted for txn recovery for other instances
-- SMON posted for undo segment recovery
-- SMON posted for undo segment shrink
-- space was found by tune down
-- space was not found by tune down
-- spare statistic 1
-- spare statistic 2
-- spare statistic 3
-- spare statistic 4
-- steps of tune down ret. in space pressure
-- TBS Extension: bytes extended
-- TBS Extension: files extended
-- TBS Extension: tasks created
-- TBS Extension: tasks executed
-- total number of times SMON posted
-- total number of undo segments dropped
-- transaction lock background get time
-- transaction lock background gets
-- transaction lock foreground requests
-- transaction lock foreground wait time
-- transaction rollbacks
-- transaction tables consistent read rollbacks
-- transaction tables consistent reads - undo records applied
-- tune down retentions in space pressure
-- undo change vector size
-- undo segment header was pinned
-- SQL+Debug cell simulated physical IO bytes eligible for predicate offload
-- cell simulated physical IO bytes returned by predicate offload