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)
(this is translated: the expected average response
in milliseconds for reading a datablock from a database file)
.)
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)
.)

0 Comments:
Kommentar veröffentlichen
<< Home