Re: Transaction accounting for Oracle

In article <1992Sep15.064241.23618_at_news.uit.no>, hm_at_odin.fna.no (Herold Myrland) writes:
> 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
>
Be a little more specific. Users perform transactions. The background processes manage the database, (writing out dirty buffers, cleaning up dead processes and deadlocks, archiving data). There is no way to map USERS to system processes because they are not related. 20 people may have updated the database before database writer decides the SGA is too full and writes out the blocks.

Maybe you really mean, how to map USERS to transactions or BACKGROUND processes to resources. Tell us what you mean. Received on Thu Sep 17 1992 - 04:37:18 CEST