As we all know v$sql / v$sql_text / v$sqlarea etc.
contains a list of sql commands recently executed.
Well, I would like to know if the transaction that executed a certain sql command was rollbacked/commited or possibly still going, and possibly also know the commit time.
I tried joining it with v$session etc., But couldn't find anything useful. Help will be appreciated.
Another thing that may help me if there is some way to look at v$sql as transactional. That is, only when the transaction that ran the sql command is commited, the information is visible to other sessions in the v$sql table.
Thank you