Re: Temporary used data area grow fast
Increase your database size or find out which of your application clients is running either 1) very large joins that materialize on disk or - more likely - 2) large transactions that write a huge undo records (will will be keept on the data volume). Huge undo records could be caused either by long-running transactions, transactions with many, many operations or transactions playing with LONG columns.
Ulf
Subject
Written By
Posted
Re: Temporary used data area grow fast
May 14, 2007 05:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.