cancel
Showing results for 
Search instead for 
Did you mean: 

buffer synchronization

Former Member
0 Kudos

is it necessary to synchronize the buffers when using the UPDATE command before UPDATING the table USR 02 ? my requirement is to unlock a client keeping in mind the issues that may arise after issuing the UPDATE command via SQL what consideratoins are to be kept in mind?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

is it necessary to synchronize the buffers when using the UPDATE command before UPDATING the table USR 02 ? my requirement is to unlock a client keeping in mind the issues that may arise after issuing the UPDATE command via SQL what consideratoins are to be kept in mind?

Hi,

No it is not necessary to sync buffers. It is done automatically. Sometimes it make some problems when the system is running on two or more application servers, but this is an exception.

Please keep in mind that if you executed an DML statement over SQLplus, you may need to execute /$sync command.

Best regards,

Orkun Gedik

Answers (2)

Answers (2)

Former Member
0 Kudos

thanks for the support !

Former Member
0 Kudos

thanks for the support !