Ask Maclean

【12c新特性】12cR1中新加入的Statistic

【12c新特性】12cR1中新加入的Statistic

 

select  A.* from v$sysstat A  where A.name not in (select B.name from v$sysstat@db_11gR2 B);

 

STATISTIC# NAME CLASS VALUE STAT_ID CON_ID
52 physical read partial requests 8 0 286702467 0
54 physical write requests optimized 8 0 2483607112 0
55 physical write request redirties 8 0 4146911311 0
56 physical write total bytes optimized 8 0 4085960041 0
57 physical write partial requests 8 0 1535615968 0
70 ka messages sent 32 0 4222258831 0
71 ka grants received 32 0 2310418695 0
81 consistent gets pin 8 248409 1168838199 0
82 consistent gets pin (fastpath) 8 240756 2910712465 0
83 consistent gets examination 8 46775 1966540185 0
84 consistent gets examination (fastpath) 8 45808 1990445227 0
86 fastpath consistent get quota limit 40 0 560973176 0
178 flashback securefile cache read optimizations for block new 8 0 955255216 0
179 flashback securefile direct read optimizations for block new 8 0 963322245 0
180 physical reads cache for securefile flashback block new 8 0 2429466467 0
181 physical reads direct for securefile flashback block new 8 0 3121545084 0
184 data warehousing scanned objects 8 0 247471814 0
185 data warehousing scanned chunks 8 0 3880771368 0
186 data warehousing scanned chunks – memory 8 0 1765983694 0
187 data warehousing scanned chunks – flash 8 0 3811273611 0
188 data warehousing scanned chunks – disk 8 0 1684884558 0
189 data warehousing evicted objects 8 0 1827708704 0
190 data warehousing evicted objects – cooling 8 0 1769197766 0
191 data warehousing evicted objects – replace 8 0 547725926 0
192 data warehousing cooling action 8 0 2905230597 0
200 Streaming Stall Reap 2 0 3489516369 0
201 Streaming No-Stall Reap 2 0 2378677367 0
210 redo writes (group 0) 2 164 2952991530 0
211 redo writes (group 1) 2 16 1083730459 0
212 redo writes (group 2) 2 0 2759403975 0
213 redo writes (group 3) 2 0 3475566097 0
214 redo writes (group 4) 2 0 1807859197 0
215 redo writes (group 5) 2 0 1792560815 0
216 redo writes (group 6) 2 0 1695728381 0
217 redo writes (group 7) 2 0 1074957749 0
218 redo writes adaptive all 2 180 3061077218 0
219 redo writes adaptive worker 2 180 3220418890 0
221 redo blocks written (group 0) 2 995 2520028696 0
222 redo blocks written (group 1) 2 301 3244346714 0
223 redo blocks written (group 2) 2 0 1273391004 0
224 redo blocks written (group 3) 2 0 1050845280 0
225 redo blocks written (group 4) 2 0 2795831152 0
226 redo blocks written (group 5) 2 0 615604096 0
227 redo blocks written (group 6) 2 0 764128333 0
228 redo blocks written (group 7) 2 0 435637049 0
229 redo write size count (   4KB) 2 145 4206847440 0
230 redo write size count (   8KB) 2 15 3604386338 0
231 redo write size count (  16KB) 2 11 1937637258 0
232 redo write size count (  32KB) 2 7 2689404784 0
233 redo write size count (  64KB) 2 0 3887142398 0
234 redo write size count ( 128KB) 2 2 2998280397 0
235 redo write size count ( 256KB) 2 0 2120393820 0
236 redo write size count ( 512KB) 2 0 3912524051 0
237 redo write size count (1024KB) 2 0 395882065 0
238 redo write size count (inf) 2 0 4145578355 0
251 redo synch time overhead (usec) 128 3142053 3961087021 0
252 redo synch time overhead count (  2ms) 128 35 1771370497 0
253 redo synch time overhead count (  8ms) 128 0 2324186582 0
254 redo synch time overhead count ( 32ms) 128 0 2882285036 0
255 redo synch time overhead count (128ms) 128 0 1234629759 0
256 redo synch time overhead count (inf) 128 3 2239006192 0
261 redo write info find 2 38 3584739253 0
262 redo write info find fail 2 0 553778103 0
267 gc cr blocks served with BPS 40 0 1600220233 0
275 gc current blocks served with BPS 40 0 1004484383 0
278 gc cr blocks received with BPS 40 0 3270643842 0
281 gc current blocks received with BPS 40 0 301773697 0
282 gc ka grants received 40 0 912334553 0
283 gc ka grant receive time 40 0 3746639269 0
289 gc cleanout saved 40 0 4119317321 0
290 gc cleanout applied 40 0 1976898865 0
291 gc cleanout no space 40 0 522936568 0
293 gc reader bypass waits 40 0 1120557156 0
298 gc force cr disk read 40 395 1058102273 0
307 AVM files created count 128 0 1887082337 0
308 AVM files deleted count 128 0 4223523824 0
309 AVM file bytes allocated 128 0 3731650962 0
310 AVM au bytes allocated 128 0 3441520794 0
311 AVM file bytes deleted 128 0 1514042146 0
312 AVM non-flash bytes requested 128 0 1829484955 0
313 AVM flash bytes requested 128 0 965137504 0
314 AVM bytes for file maps 128 0 2904743103 0
315 AVM bytes read from flash 128 0 4263147678 0
316 AVM bytes read from disk 128 0 2004986892 0
317 AVM count when 10% of buckets in pb 128 0 652947275 0
318 AVM count when 25% of buckets in pb 128 0 3588709547 0
319 AVM count when 50% of buckets in pb 128 0 2879014823 0
320 AVM count when 75% of buckets in pb 128 0 1964315023 0
321 AVM count when 90% of buckets in pb 128 0 226051874 0
322 AVM count – borrowed from other node 128 0 4037843577 0
323 AVM count – searched in pb 128 0 4000147916 0
324 AVM spare statistic 1 128 0 47653185 0
325 AVM spare statistic 2 128 0 3191674657 0
326 AVM spare statistic 3 128 0 2665872976 0
327 AVM spare statistic 4 128 0 2816010972 0
328 AVM spare statistic 5 128 0 4250363583 0
329 AVM spare statistic 6 128 0 3756487597 0
330 AVM spare statistic 7 128 0 2604881032 0
331 AVM spare statistic 8 128 0 176682480 0
345 storage index soft misses in bytes 8 0 2809906174 0
353 cell num smart IO sessions in rdbms block IO due to open fail 64 0 1611570469 0
363 cell num smartio automem buffer allocation attempts 64 0 145506540 0
364 cell num smartio automem buffer allocation failures 64 0 727055891 0
365 cell num smartio transient cell failures 64 0 2276204331 0
366 cell num smartio permanent cell failures 64 0 299072157 0
367 cell num bytes of IO reissued due to relocation 64 0 3754903472 0
388 recovery marker 2 0 2982845773 0
389 cvmap unavailable 2 0 3849353583 0
390 recieve buffer unavailable 2 0 3480097050 0
462 tracked transactions 128 0 4230695614 0
463 foreground propagated tracked transactions 128 0 2081753160 0
464 slave propagated tracked transactions 128 0 275867045 0
465 large tracked transactions 128 0 1755433832 0
466 very large tracked transactions 128 0 4033000846 0
467 fbda woken up 128 0 138331311 0
468 tracked rows 128 0 943642878 0
469 CLI Flush 128 73 670819718 0
470 CLI BG attempt Flush 128 73 2751550570 0
471 CLI Client Flush 128 0 2418073855 0
472 CLI Imm Wrt 128 0 47996927 0
473 CLI Buf Wrt 128 0 1466815534 0
474 CLI Thru Wrt 128 2 2721289668 0
475 CLI Prvtz Lob 128 0 1688196485 0
476 CLI SGA Alloc 128 32 2076026298 0
477 CLI BG ENQ 128 73 2537508108 0
478 CLI BG Fls done 128 2 1898500432 0
479 CLI Flstask create 128 73 4150293767 0
480 CLI bytes fls to table 128 1376 872375576 0
481 CLI bytes fls to ext 128 0 2251457522 0
482 Heatmap SegLevel – Write 128 0 2305866014 0
483 Heatmap SegLevel – Full Table Scan 128 0 3635715785 0
484 Heatmap SegLevel – IndexLookup 128 0 4088384827 0
485 Heatmap SegLevel – TableLookup 128 0 26595750 0
486 Heatmap SegLevel – Flush 128 0 3466367062 0
487 Heatmap SegLevel – Segments flushed 128 0 2885452372 0
504 KTFB alloc req 128 0 3506976771 0
505 KTFB alloc space (block) 128 0 254882839 0
506 KTFB alloc time (ms) 128 0 573758863 0
507 KTFB free req 128 25 1286187813 0
508 KTFB free space (block) 128 1528 1243401580 0
509 KTFB free time (ms) 128 266 408510199 0
510 KTFB apply req 128 16 2829590811 0
511 KTFB apply time (ms) 128 902 1827629900 0
512 KTFB commit req 128 9 2268695636 0
513 KTFB commit time (ms) 128 16659 3807444826 0
514 KTFB alloc myinst 128 0 637674164 0
515 KTFB alloc steal 128 0 3819194715 0
516 KTFB alloc search FFB 128 0 1572111054 0
522 Heatmap BlkLevel Tracked 128 0 417269865 0
523 Heatmap BlkLevel Not Tracked – Memory 128 0 3244920981 0
524 Heatmap BlkLevel Not Updated – Repeat 128 0 1235344528 0
525 Heatmap BlkLevel Flushed 128 0 3201601810 0
526 Heatmap BlkLevel Flushed to SYSAUX 128 0 153666168 0
527 Heatmap BlkLevel Flushed to BF 128 0 329477246 0
528 Heatmap BlkLevel Ranges Flushed 128 0 3869669302 0
529 Heatmap BlkLevel Ranges Skipped 128 0 120128078 0
530 Heatmap BlkLevel Flush Task Create 128 0 1236100146 0
531 Heatmap Blklevel Flush Task Count 128 0 1887039906 0
568 index compression (ADVANCED LOW) prefix change at block 128 0 1089998764 0
569 index compression (ADVANCED LOW) prefix no change at block 128 0 2879842113 0
570 index compression (ADVANCED LOW) blocks not compressed 128 0 3703793538 0
571 index compression (ADVANCED LOW) reorg avoid split 128 0 2501129012 0
573 index compression (ADVANCED HIGH) leaf block splits avoided 128 0 228768206 0
575 index compression (ADVANCED HIGH) leaf block 90_10 splits faile 128 0 3445701516 0
612 HSC OLTP Compression wide compressed row pieces 128 0 784760009 0
669 EHCC Used on ZFS Tablespace 128 0 2536989047 0
670 EHCC Used on Pillar Tablespace 128 0 3901974308 0
671 EHCC Conventional DMLs 128 0 547882683 0
672 EHCC Block Compressions 128 0 2852097326 0
673 EHCC Attempted Block Compressions 128 0 726324667 0
674 SecureFiles DBFS Link Operations 128 0 408804124 0
675 SecureFiles Move to DBFS Link 128 0 2159528439 0
676 SecureFiles Copy from DBFS Link 128 0 3313150606 0
677 SecureFiles Get DBFS Link Reference 128 0 3776855272 0
678 SecureFiles Put DBFS Link Reference 128 0 1020980477 0
679 SecureFiles Implicit Copy from DBFS Link 128 0 2864160252 0
680 SecureFiles DBFS Link streaming reads 128 0 2291010287 0
681 SecureFiles DBFS Link Overwrites 128 0 3546571658 0
682 index cmph ld, CU under-est 128 0 3487869306 0
683 index cmph ld, CU fit, add rows 128 0 3074245919 0
684 index cmph ld, CU fit 128 0 312995821 0
685 index cmph ld, CU over-est 128 0 3287792462 0
686 index cmph ld, retry in over-est 128 0 2794871331 0
687 index cmph ld, CU negative comp 128 0 747638515 0
688 index cmph ld, lf blks flushed 128 0 3933169485 0
689 index cmph ld, lf blks w/o CU 128 0 2058955770 0
690 index cmph ld, lf blks w/o unc r 128 0 1877031790 0
691 index cmph ld, lf blks w/ und CU 128 0 500852118 0
692 index cmph ld, rows compressed 128 0 2461980696 0
693 index cmph ld, rows uncompressed 128 0 1487477542 0
694 index cmph gencu, uncomp sentinals 128 0 3972713215 0
707 Number of NONE redactions 1 0 2910416594 0
708 Number of FULL redactions 1 0 4021003316 0
709 Number of PARTIAL redactions 1 0 2340397149 0
710 Number of FORMAT_PRESERVING redactions 1 0 2739332778 0
711 Number of RANDOM redactions 1 0 2308447938 0
712 Number of REGEXP redactions 1 0 3081010860 0
795 OLAP Paging Manager Cache Hit 64 0 249788237 0
796 OLAP Paging Manager Cache Miss 64 0 2631123639 0
797 OLAP Paging Manager New Page 64 0 1639856938 0
798 OLAP Paging Manager Cache Write 64 0 2077400790 0
799 OLAP Session Cache Hit 64 0 3766195924 0
800 OLAP Session Cache Miss 64 0 1569481295 0
801 OLAP Aggregate Function Calc 64 0 3109348342 0
802 OLAP Aggregate Function Precompute 64 0 352609299 0
803 OLAP Aggregate Function Logical NA 64 0 2269374713 0
804 OLAP Paging Manager Pool Size 64 0 3621573995 0
805 OLAP Import Rows Pushed 64 0 3846608240 0
806 OLAP Import Rows Loaded 64 0 2782483173 0
807 OLAP Row Source Rows Processed 64 0 1032576542 0
808 OLAP Engine Calls 64 0 4076583183 0
809 OLAP Temp Segments 64 0 3547622716 0
810 OLAP Temp Segment Read 64 0 1927042645 0
811 OLAP Perm LOB Read 64 0 2809117898 0
812 OLAP Paging Manager Cache Changed Page 64 0 2200669834 0
813 OLAP Fast Limit 64 0 283242358 0
814 OLAP GID Limit 64 0 1120107350 0
815 OLAP Unique Key Attribute Limit 64 0 3812252850 0
816 OLAP INHIER Limit 64 0 2844959843 0
817 OLAP Full Limit 64 0 2189109011 0
818 OLAP Custom Member Limit 64 0 3030144806 0
819 OLAP Row Id Limit 64 0 3437716459 0
820 OLAP Limit Time 64 0 2592657924 0
821 OLAP Row Load Time 64 0 953132701 0

Posted

in

by

mac

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *