Someone asked me he hit wait event transaction in v$session_wait in his ops database, and i cannot explain it.
I never met someting like that in a normal running database, except for sometime i experience in a read only standby database where undo segment recovery and transaction appear in v$session_wait and this session loops.I have to do shutdown abort and recover the database.
The question is raised when we are discussing implementing High Avalibility in oracle system. If you can read chinese(then you are from china), please take a look and see if you can help: