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)
Based on your assumptions you are a danger to your employer and should
be immediately terminated. And I couldn't be more serious.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jul 06 2006 - 14:37:45 CDT
