Re: Confuse in Commited Data Pls Help

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 7 Jul 2006 10:38:52 -0700
Message-ID: <1152293932.337520.131760@s16g2000cws.googlegroups.com>

aman.oracle.dba wrote:
> Hello DBAs,
>
> Suppose, I am not committing my data since morning and doing so many
> entries.
> where
> database is in noarchivelog
> SGA size is 100M
> undo_retention is 900
> undo_tablespace size is 10M
> log groups are 3
> log switched since morning 15
>
> I already inserted data for 140M (which is more than SGA Size) where is
> my uncommited data, if it is not in SGA and LOG Files or UNDO.
>
> (these are just assumptions)

Keep in mind that INSERTs only store (IIRC) the rowid for undo, as that is all it needs to "undo" the transaction (there is no before image of the row). If you UPDATE those same rows after they are INSERTed, and if the total bytes of the updated values exceeds what is available in your UNDO tablespace, an "unable to extend" exception will be thrown by Oracle for the UPDATE.

Regards,

Steve Received on Fri Jul 07 2006 - 12:38:52 CDT