Oracle - v $ sql determines if sql command has been executed

Question

As we all know v$sql/ v$sql_text/ v$sqlareaetc. contains a list of recently executed sql commands.

Well, I would like to know if the transaction that was executing the particular sql command was rollback / completion or possibly still ongoing, and maybe also know the commit time.

I tried joining it with v $ session, etc., but could not find anything useful. Help will be appreciated.

Another thing that can help me if there is a way to look at v$sqlhow transactional is. That is, only when the transaction in which the sql command is executed is executed, the information is visible to other sessions in the v $ sql table.

thanks

Answer 1

: ?

v$sql x$, . , , , . , .