Hi!
>>>>> "Jim" == Jim Starkey <jstarkey@stripped> writes:
Jim> Could somebody give me a clue how this gets communicated to a storage
Jim> engine?
For the storage engine, there is nothing to do, except possible sync
all table date to disk when all handlers to a table is closed.
All the logic and protection is done on the upper level.
Here is how "Flush Tables with Read Locks" works:
- Put a protection in place that stops anyone from open a table.
- Close all open table handlers that can be closed. Mark all that are
in use to be closed at statement end.
- Wait until all table handlers have been closed.
- Set a global write protection flag that will cause any statement
that modifies tables to wait.
- Allow read only queries to continue.
Regards,
Monty

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.