ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 关于DBIO_EXPECTED参数

关于DBIO_EXPECTED参数

原创 Linux操作系统 作者:饼干lr 时间:2011-08-03 15:38:21 0 删除 编辑

摘自2days performance tuning (e10822.dbf)

Setting the DBIO_EXPECTED Parameter

ADDM analysis of I/O performance partially depends on a single argument,

DBIO_EXPECTED, that describes the expected performance of the I/O subsystem. The

value of DBIO_EXPECTED is the average time it takes to read a single database block,

in microseconds. Oracle Database uses the default value of 10 milliseconds, which is

an appropriate value for most hard drives. You can choose a different value based on

the characteristics of your hardware.

To determine the correct setting for the DBIO_EXPECTED initialization parameter:

1. Measure the average read time of a single database block for your hardware.

This measurement must be taken for random I/O, which includes seek time if you

use standard hard drives. Typical values for hard drives are between 5000 and

20000 microseconds. See Oracle Database Performance Tuning Guide to learn how to

assess the I/O capability of the storage subsystem.

2. Set the value one time for all subsequent ADDM executions.

For example, if the measured value is 8000 microseconds, then execute the

following PL/SQL code as the SYS user:

EXECUTE DBMS_ADVISOR.SET_DEFAULT_TASK_PARAMETER(

'ADDM', 'DBIO_EXPECTED', 8000);

meanwhile:see the value
SELECT * FROM DBA_ADVISOR_DEF_PARAMETERS WHERE PARAMETER_NAME='DBIO_EXPECTED';

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22372063/viewspace-703989/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 关于AWR 中DB time
请登录后发表评论 登录
全部评论

注册时间:2010-05-11

  • 博文量
    8
  • 访问量
    26741