Oracle 10G DB Control Reinstall on 10G R1 and R2

Reinstallation is different in R1 and R2 (on Windows xp)

on R1:
uninstall with the cmdline tool emca:
emca -x SID
reinstall again with java based DB Config Agent:
dbca

in spite of a "sys as sysdba" login in sqlplus is working,
after installation of the DB Control there may be the
need to do a alter user sys identified by xxx (same password)
to make the login work in the DB Control.

on R2 all can be done with emca:
emca -deconfig dbcontrol db -repos drop
install again goes with:
emca -config dbcontrol db -repos create

for additional infos see
Configuring Database Control with EMCA

Oracle 10 G DB Control : Changing Language in GUI

oracle db control is a webbased application for (advanced) configuration and
administration and tuning of a single oracle instance. changing the language of the webapp for is very simple - it has nothing to do with NLS_LANGUAGE settings. a reinstall or re-applying of a configuration via emctl or emca or dbca is not needed.
all to do is to change the language _clientside_ in the browser settings .)
this works immediate, even without a restart of the browser.

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)

.)

googlemail as an external web-harddrive

googlemail offers 2.5 gb free storage. as noone uses this for mails someone got the idea to use it as a filestorage medium as its possible to save attachments in drafts. the following small tool implements a virtual drive in windows explorer this is a fine tool to share some file between home and work location:

http://www.viksoe.dk/gmail