Oracle Database Discussions

Hi,

I'm using Oracle Total Recal on a table. i'm facing some problems in querying the data from this table. My problem is,

We have added one table into total recall. It had 36 rows initially. Then we updated that table for 180 times.

We followed two methods in updating the table.

Method 1:
In method 1 we committed the table after updating the table for 180 times. When we queried it using Oracle Total Recall it is giving only 72 rows. i.e. initial 36 rows and final 36 rows. It skipped all the changes which we made before committing. We assume that this is the functionality of Oracle Read Consistency.

Method 2:
Based on our method 1 result we assume that commit is required for each update statement. So we committed the table after every update. When we queried the table immediately after the 180 updates had done it gave 216 rows. Initial 36 rows + updated 180 rows. Everything perfect. But when we tried to query it after some time say half an hour its giving an error,

ERROR at line 1:
ORA-01555: snapshot too old: rollback segment number 9 with name
"_SYSSMU9_1192403689$" too small


I googled and serached some blogs. But i could not understand the solution they have given. Please help me in sorting it out.

Thanks in advance.