Hi,

1) Optimestic means....the table is open for read/write over entire network for all users/sessions. We can move the cursor, backward or forward dynamically.

2) Pessimestic means... the table is open for read/write only for that current session. The other session users can not edit the same.