Techniques for maintaining consistency for different requestors of files in a database management system

A computer-readable storage medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the steps of:

• receiving a request to perform a file system operation, wherein performance of said file system operation requires performance of a plurality of database operations involving one or more resources;
• performing said file system operation,
• wherein performing said file system operation comprises the steps of:
• obtaining a first set of locks that apply to said one or more resources, wherein each lock in said first set of locks is a first type of lock;
• wherein the first type of lock is a file-based lock;
• performing said plurality of database operations in a plurality of database transactions;
• for each database transaction of said plurality of transactions, obtaining a second set of locks on the resources, of said one or more resources, that are involved in database operations that are performed during said database transaction, wherein each lock in said second set of locks is a second type of lock;
• wherein the second type of lock is database lock;
• releasing locks of said second type of lock in response to successful completion of the corresponding database transaction;
• wherein releasing locks of said second type includes releasing a lock on a particular resource involved in a particular database transaction upon successful completion of the database transaction prior to successful completion of said file system operation;
• and
• releasing locks of said first type of lock in response to successful completion of said file system operation.