Re: Confuse in Commited Data Pls Help

On 6 Jul 2006 10:58:18 -0700, "aman.oracle.dba" <aman.oracle.dba_at_gmail.com> 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)

How about changing profession?

--
Sybrand Bakker, Senior Oracle DBA