on 07-24-2011 7:35 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for the support !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for the support !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.