Identify Unix process which updated the database

[hhood]

How could you identify the Unix process that is responsible for creating a record in the Database. For instance, if I use sqlplus to create a record in the database, then "qlplus" is the name of the unix process that updated the database. The process could be an application. I believe this information is store somewhere in a database table. The question is which table.

I am using Oracle 8.1.7 (8i) on Linux (Redhat 7.0)
thanks in advance.

 

[sem]

You may find it in v$process.spid. Join this view with v$session by paddr=addr to find the appropriate Oracle session.