亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Test oracle db iops

系統 2118 0

Today, i need to test one database's iops and do something for oracle db's io test.

How to test the db's iops?

It can use oracle's pl/sql package taht is dbms_resource_manager.calibrate_io.

Here is the introduction of that procedure.

?

CALIBRATE_IO Procedure

?

This procedure calibrates the I/O capabilities of storage. Calibration status is available from the V$IO_CALIBRATION_STATUS view and results for a successful calibration run are located in DBA_RSRC_IO_CALIBRATE table.


    DBMS_RESOURCE_MANAGER.CALIBRATE_IO (

   num_physical_disks      IN  PLS_INTEGER DEFAULT 1,

   max_latency             IN  PLS_INTEGER DEFAULT 20,

   max_iops                OUT PLS_INTEGER,

   max_mbps                OUT PLS_INTEGER,

   actual_latency          OUT PLS_INTEGER); 
  

?

Parameter Description

num_physical_disks

Approximate number of physical disks in the database storage

max_latency

Maximum tolerable latency in milliseconds for database-block-sized IO requests

max_iops

Maximum number of I/O requests per second that can be sustained. The I/O requests are randomly-distributed, database-block-sized reads.

max_mbps

Maximum throughput of I/O that can be sustained, expressed in megabytes per second. The I/O requests are randomly-distributed, 1 megabyte reads.

actual_latency

Average latency of database-block-sized I/O requests at max_iops rate, expressed in milliseconds


?

?

Only users with sysdba can run this procedure to test the ions, ?only one calibrate_io procedure running at a time and it will be simultaneously generate record on all node in real application cluster, for example


?

    sys@QDATA>DECLARE

  2    lat  INTEGER;

  3    iops INTEGER;

  4    mbps INTEGER;

  5  BEGIN

  6

  7     DBMS_RESOURCE_MANAGER.CALIBRATE_IO (2, 10, iops, mbps, lat);

  8

  9    DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops);

 10    DBMS_OUTPUT.PUT_LINE ('latency  = ' || lat);

 11    dbms_output.put_line('max_mbps = ' || mbps);

 12  end;

 13  /



max_iops = 71801

latency  = 1

max_mbps = 1134



PL/SQL procedure successfully completed.


  

?

?

Views for I/O calibration results

    SQL> desc V$IO_CALIBRATION_STATUS

  Name                                      Null?    Type

  ----------------------------------------- -------- ----------------------------

  STATUS                                             VARCHAR2(13)

  CALIBRATION_TIME                                   TIMESTAMP(3)

 

SQL> desc gv$io_calibration_status

  Name                                      Null?    Type

  ----------------------------------------- -------- ----------------------------

  INST_ID                                            NUMBER

  STATUS                                             VARCHAR2(13)

  CALIBRATION_TIME                                   TIMESTAMP(3)

 

Column explanation:

-------------------

STATUS:

  IN PROGRESS   : Calibration in Progress (Results from previous calibration

                  run displayed, if available)

  READY         : Results ready and available from earlier run

  NOT AVAILABLE : Calibration results not available.

 

CALIBRATION_TIME: End time of the last calibration run


  

DBA table that stores I/O Calibration results

    SQL> desc DBA_RSRC_IO_CALIBRATE

  Name                                      Null?    Type

  ----------------------------------------- -------- ----------------------------

  START_TIME                                         TIMESTAMP(6)

  END_TIME                                           TIMESTAMP(6)

  MAX_IOPS                                           NUMBER

  MAX_MBPS                                           NUMBER

  MAX_PMBPS                                          NUMBER

  LATENCY                                            NUMBER

  NUM_PHYSICAL_DISKS                                 NUMBER
  

?


?

Test oracle db iops


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 精品综合在线 | 亚洲成a人片77777kkk | 日韩欧美a级高清毛片 | 99视频全部免费精品全部四虎 | 亚洲精品久久久久久下一站 | 一本色道久久综合狠狠躁 | 午夜一级在线 | 青青草久热精品视频在线观看 | 欧美性猛交ⅹxxx乱大交按摩 | www一区| 久久久久四虎国产精品 | 97在线观看播放 | 国内拍拍自拍视频在线观看 | 一区二区亚洲精品 | 久久不射视频 | 99久久精品国产9999高清 | 久久草精品视频 | 伊人影院在线视频 | 午夜免费福利在线 | 在线视频这里只有精品 | 日韩免费一级毛片欧美一级日韩片 | 羞羞视频免费网站在线 | 国产成人精品福利色多多 | 日韩欧美网站 | 99精品国产高清一区二区麻豆 | 日本中文字幕不卡 | 国产精品全国探花泡良大师 | 国产一区视频在线免费观看 | 精品久久一 | 狠狠色丁香婷婷久久综合不卡 | 性欧美视频a毛片在线播放 性欧美视频在线观看 | 日本人xx视频免费视频 | 精品1区2区3区 | 久久99久久99小草精品免视看 | 人人爱天天做夜夜爽毛片 | 亚洲七七久久综合桃花 | 99er视频 | 国产精品视频男人的天堂 | 国产在视频线精品视频2021 | 欧美综合天天夜夜久久 | 四虎免费入口 |