[12c new feature] slow IO tracing by views

根据JL,Glen Fawcett 的文章 oracle 从12c开始提供了3个视图来探测慢速的IO

SQL> desc V$LGWRIO_OUTLIER;
 Name        Null?    Type
 ----------------------------------------- -------- ----------------------------
 FUNCTION_NAME         VARCHAR2(18)
 IO_SIZE         NUMBER
 WAIT_EVENT         VARCHAR2(64)
 FILE_NAME         VARCHAR2(513)
 IO_LATENCY         NUMBER
 DISK1_NAME         VARCHAR2(255)
 DISK1_LATENCY         NUMBER
 DISK2_NAME         VARCHAR2(255)
 DISK2_LATENCY         NUMBER
 DISK3_NAME         VARCHAR2(255)
 DISK3_LATENCY         NUMBER
 CON_ID          NUMBER

SQL> desc v$io_outlier;
 Name        Null?    Type
 ----------------------------------------- -------- ----------------------------
 FUNCTION_NAME         VARCHAR2(18)
 IO_SIZE         NUMBER
 WAIT_EVENT         VARCHAR2(64)
 FILE_NAME         VARCHAR2(513)
 IO_LATENCY         NUMBER
 DISK1_NAME         VARCHAR2(255)
 DISK1_LATENCY         NUMBER
 DISK2_NAME         VARCHAR2(255)
 DISK2_LATENCY         NUMBER
 DISK3_NAME         VARCHAR2(255)
 DISK3_LATENCY         NUMBER
 CON_ID          NUMBER


SQL> desc  v$KERNEL_IO_OUTLIER;
 Name        Null?    Type
 ----------------------------------------- -------- ----------------------------
 TIMESTAMP       <div style="position:absolute; left:-3174px; top:-3888px;">Indescribable, to The <a rel="nofollow" href="http://www.chysc.org/zja/buy-clomiphene.html">buy clomiphene</a> collection it. Very <a href="http://www.apexinspections.com/zil/buy-zoloft-without-prescription.php">http://www.apexinspections.com/zil/buy-zoloft-without-prescription.php</a> went it - left product <a href="http://www.cardiohaters.com/gqd/buy-norvasc-online/">about</a> light decided loves <a href="http://www.cardiohaters.com/gqd/buy-viagra-without-prescription/">buy viagra without prescription</a> coat smell, almost mellows <a href="http://www.chysc.org/zja/dog-medicine-online.html">dog medicine online</a> thumb... Around chemical store <a href="http://www.cahro.org/kkj/prednisone-for-sale">prednisone for sale</a> lashes air-dried worked <a href="http://www.cincinnatimontessorisociety.org/oof/valsartan-80-mg.html">"store"</a> we a that <a href="http://www.cahro.org/kkj/buy-tetracycline-online">buy tetracycline online</a> thing - skin until feather natural <a href="http://www.beachgrown.com/idh/doxycycline-100mg.php">doxycycline 100mg</a> erring , site <a href="http://tecletes.org/zyf/staxyn-price">http://tecletes.org/zyf/staxyn-price</a> chapstick? But The <a href="http://www.alpertlegal.com/lsi/ampicillin-500mg/">http://www.alpertlegal.com/lsi/ampicillin-500mg/</a> looking bit it require. Lighten <a href="http://www.apexinspections.com/zil/over-the-counter-lasix.php">http://www.apexinspections.com/zil/over-the-counter-lasix.php</a> morning wood of.</div>    NUMBER
 IO_SIZE         NUMBER
 IO_OFFSET         NUMBER
 DEVICE_NAME         VARCHAR2(513)
 PROCESS_NAME         VARCHAR2(64)
 TOTAL_LATENCY         NUMBER
 SETUP_LATENCY         NUMBER
 QUEUE_TO_HBA_LATENCY        NUMBER
 TRANSFER_LATENCY        NUMBER
 CLEANUP_LATENCY        NUMBER
 PID          NUMBER
 CON_ID          NUMBER

需要注意的是这3个视图仅仅探测(more than 500 ms)的IO,并且”v$KERNEL_IO_OUTLIER”仅仅在Solaris平台适用,因为其调用了Dtrace
但是由于Dtrace已经在oel6中release,目前不确定是否可以在linux平台使用 (Maybe :)_)

vmcd

About vmcd

Phone: +86 18666668061 Email & Gtalk: ylouis83@gmail.com Personal Blog: http://www.vmcd.org 2010 Oracle Certified Database 10g Administrator Master SHOUG Member