|
|
| Re: How Can I calculate the DBIO_EXPECTED? [message #333705 is a reply to message #333642] |
Mon, 14 July 2008 03:43   |
alanm
Messages: 284
Registered: March 2005
|
Senior Member |
|
|
hi,
To determine the correct setting for the DBIO_EXPECTED parameter:
Measure the average read time of a single database block for your hardware.
This measurement needs to 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.
Set the value one time for all subsequent ADDM executions.
For example, if the measured value if 8000 microseconds, run the following command as SYS user:
EXECUTE DBMS_ADVISOR.SET_DEFAULT_TASK_PARAMETER(
'ADDM', 'DBIO_EXPECTED', 8000);
this is from a google search.
cheers
Alan
[Updated on: Thu, 17 July 2008 11:14] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
