ora-600 4147 occurs when you query flashback_transaction_query
in oracle 10204,I query the view like that:
SELECT /*+ ordered*/* FROM flashback_transaction_query t WHERE t.table_name='TEST_A' AND t.logon_user='FZTXT';
It takes a long time.at last, the error ora-600 4147 occur. -->fuck
though metalink,It's a bug and fixed in 10205 and above version of oracle.
During queries on FLASHBACK_TRANSACTION_QUERY, it is possible for some piece of undo required for the query to be in-memory (ie. yet to be written to the
undo blocks). Attempts the retrieve the relevant undo off its target undo block lead to ORA-600 [4147] during selects on FLASHBACK_TRANSACTION_QUERY.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14730395/viewspace-673881/ ，如需转载，请注明出处，否则将追究法律责任。
