FLUSH statement
The manual information for the TABLES option says:
"closes all open tables and forces all tables in use to be closed. This also flushes the query cache."
What exactly does it mean to "close all open tables"? Will this impact a user who is performing selects/inserts/updates/deletes?
(At present the FLUSH directive is executed prior to backup - I want to assess whether this means our daily backup has the potential to impact users).
Thanks in advance,
Chris.
Subject
Written By
Posted
FLUSH statement
October 21, 2004 08:27PM
Sorry, you can't reply to this topic. It has been closed.
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.