Transaction accounting for Oracle
Date: Tue, 15 Sep 1992 06:42:41 GMT
Message-ID: <1992Sep15.064241.23618_at_news.uit.no>
Are there any who know how to map the machine resources consumed
by the Oracle processes (different deamons) onto the Oracle user
which initiated the command?
Whenever an application (SQL*Forms, SQL*Plus, others...) connects
to a DB this is done in the name of a certain Oracle user. However
the Unix system resources consumed by the DB deamons are logged
onto Unix user 'root' or 'ora' (depending on which users that runs
them).
I am looking for a possibility to log the Oracle deamon activities
caused by each Oracle users's transactions (SELECT, FETCH, UPDATE,
INSERT, DELETE, ...) .
Does anybody out there know of such a beastie.
Herold Myrland
Manager of FUNN-Narvik as (Norwegian R&D Network, Narvik)
E-mail: hm_at_fna.no Received on Tue Sep 15 1992 - 08:42:41 CEST