Home -> Usenet -> comp.databases.oracle -> Uncommited Transaction For a very Long time duration.

Uncommited Transaction For a very Long time duration.

From: <kortikar_at_mipos2.intel.com>
Date: 4 Aug 92 18:06:16 GMT
Message-ID: <12691_at_inews.intel.com> 






What will oracle do in following scenario
Assume Oracle is running in noarchivelog mode. And there are two log files.



Monday : 9:00 AM user A enters a small update on one relatively unused table


         He does not commit transaction and goes on a vacation.



Otherusers continue to do processing thereby eventually filling log file 1



what happens when 1. log file 1 fills


                  2. log file 2 fills.



Specifically 1. is the transaction lost ?


             2. Does oracle halt waiting for someone to commit the transaction?



Thanks in advance.



Aniruddha Kortikar (kortikar_at_mipos2.intel.com)
Received on Tue Aug 04 1992 - 20:06:16 CEST












Original text of this message