Query to find all transactions for a particular user

[vijayalakshmip]

Hi All,

I want a query to findout all(count) the transaction( insert/ update /delete) for all tables in a particular user for the database.All the transaction happened in single day,in tables. I don’t have any timestamp or date field in that table.

Could you please tell me,Is it possible?. I tried and didn’t find any clue?.

Thanks,

[debasisdas]

Kindly post what you have tried .

[vijayalakshmip]

Kindly post what you have tried .

Tried querying V$Session to check for active sessions.
Then a join in v$session and v$transaction view to get the number of
transactions being executed in database.But it resulted in the number of transactions currently running.Kindly help for my query.