MrUll's

Mai 16, 2006

Reason why Oracle is slow

during exploring new features in Oracle 10G Release 2 i found by accident
the proof why oracle is so slow (in spite of this is not a new feature)


SQL> select parameter_name, parameter_value, description
from dba_advisor_def_parameters
where advisor_name = 'ADDM' and parameter_name like 'DBIO%';

PARAMETER_NAME PARAMETER_VALUE
---------------------- -----------------
DESCRIPTION
----------------------------------------
DBIO_EXPECTED 10000
Die erwartete Antwortzeit in Millisekunden
f³r das Lesen eines Datenblocks aus einer Datendatei




(this is translated: the expected average response
in milliseconds for reading a datablock from a database file)

.)