Last commands

[Doutorjava]

Guys, I'vê seen something about it, but I do not remember, it's the following Oracle keeps all the commands he performs on some table, what's this table?

Thanks

[dr_gori]

It is not quite a "table"
Oracle can record everything being changing in Archives.
With this it is possible to retrieve the bank information to the moment of the "crash".

[Doutorjava]

I'm not sure if it's a table! But my need is not to recover the data. I just performed some commands and would like to run them again, I know some tools (ex: TOAD) keeps the last scripts, but I did not do it for it, so I lost the commands.

[dr_gori]

I do not think it will be possible to recover this.
You see: These are thousands of Selects / Updates / Deletes that are made every minute. Where did Oracle store these scripts?

This type of "log" of the executed commands is very common only in development tools (like you said toad, pl / sqldeveloper, etc.).

[pzuchelli]

Expensive,


Oracle stores the DML commands in the Red Log Files for database recovery in case of failure. If the database is in Archive Log Mode these logs are archived on a device.

I hope I could have helped.


Hugs