Transaction logs

[DBA_LUCAS]

Environment information:
* Oracle version: 11g
* Operating system: Windowns

Expensive friends,
Do you know if you have any form of Oracle to get logs log (inserts, deletes, updates, etc ...) made by the application ??

ex: a sale that is made by a box ...

Thanks;

[victorhugomuniz]

I think it's just a trace but ..


for real time you can pick up v$session filtering through the application and v$sql picking up the instruction

[elidias7]

Oops!

to connect the session trace or in a more unusual way it is to use LogMiner.

Hugs,

[DBA_LUCAS]

Explain the operation of log_miner please ...

[elidias7]

Oops!

It is a package in Oracle that makes you see the content of the Archive logs.

Hugs,

[tiago.steil]

What do you need is a record of all transactions made in a determine table?

Would it be a log trigger?

[DBA_LUCAS]

In fact it would not be in a table only, it would be all transactions.
Ex: You have a front of a box and want to know everything that was sold, who sold, or who connected in the bank, what time, porque gave that insert in such a place that left my stock different of what was ...

Without such a log any person who has access to my bank for some user who has permissions can change a sale or purchase without anyone noticing ... I'm reading about The log mines but I still can not run ...

[adambarao]

Good afternoon friend, in my opinion the best way to do this would be through the bank audit.

Activating the database audit, you can choose which commands either audit as <create user> drop_user Select, Insert, Update, Delete, between several others. Even choose which users will be audited, or activate for all users.