ora-600 4147 occurs when you query flashback_transaction_query

最新推荐文章于 2025-12-30 12:48:39 发布

转载最新推荐文章于 2025-12-30 12:48:39 发布 · 108 阅读

文章标签：

#数据库

本文描述了在Oracle10g版本10.2.0.4中使用Flashback Transaction Query进行查询时遇到的一个长时间运行并最终导致ORA-600[4147]错误的问题。该问题是由于部分撤销数据尚未写入撤销块导致的。此问题已在10.2.0.5及更高版本中修复。

    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. --&gtfuck
    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博客 ” ，链接：http://blog.itpub.net/14730395/viewspace-673881/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14730395/viewspace-673881/