A method and apparatus for providing file system operation locks at a
database server is provided. A database server may employ database locks
and file system operation locks in servicing requests from consistent
requestors and inconsistent requesters. A database lock is a lock that is
obtained in response to performing a database operation, and the database
lock is released when the database operation has successfully completed.
A file system operation lock is a lock that is obtained in response to
performing an OPEN file system operation, and the file system operation
lock is released when a CLOSE file system operation is performed. The
database server may use a temporary copy of the resource, which reflects
all the current changes that have been made to the resource by database
operations, in servicing consistent requestors, and may use the original
version of the resource in servicing inconsistent requesters.