Oracle only guarantee that after commit of a transaction
( either automatic or manual), all new data is at the redo
log. That means:
SQL>commit
Commit complete
SQL>
As long as "Commit complete" show up, all new info is in
redo log.
As if new data has been to data file, it depends. maybe some
new info has been to data file by DBWR, maybe all stay in
the data buffer cache.
Before commit, all rollback info is in rollback segment.