One of my applications inserts a new record into Oracle Server. How do I know exactly which table is to be inserted/modified?
The INSERT statement will indicate which table will get the new row. For instance:
INSERT INTO employee VALUES ('Bob');
In the above example, the table following the INTO clause is the table that will receive the new row. If you have access to the application code, you can simply look for INSERT statements.
If you do not have access to the application code, then you will want to identify your session in V$SESSION. Find the SID and SERIAL# for your session. Then in another SQL*Plus session, issue the following command:
Substitute the SID and SERIAL# you obtained from V$SESSION. Then run the application to insert the new data. A trace file will be generated in your database's USER_DUMP_DEST directory and will contain the INSERT statement the application issued.