Re: Confuse in Commited Data Pls Help

"aman.oracle.dba" <aman.oracle.dba_at_gmail.com> a écrit dans le message de news: 1152208698.294504.91140_at_p79g2000cwp.googlegroups.com...
| 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)
|

Concepts guide is your answer:

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

Regards
Michel Cadot Received on Thu Jul 06 2006 - 13:21:58 CDT