Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Confuse in Commited Data Pls Help
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)
>
It's in the buffer cache, and/or the datafiles, and the logfiles. Other sessions cannot see it because it's uncommitted. Just do a commit and they can see it.
You really need to get some training or read the manuals. Received on Fri Jul 07 2006 - 12:46:36 CDT