Hi, Guess what, it did count the uncommitted records...

I've done a test,

Step 1: run "select count(*) from table1;" -- return 3

Step 2: begin a transaction to insert 3 records into table 1, without end/rollback the transaction

Step 3: open another session and run "select count(*) from table1;" there.-- which returned 6

Step 4: I rollback the transaction;

Step 5: run "select count(*) from table1;" again. --which returned 3.

Thanks all for help.

V