Problem solve Get help with specific problems with your technologies, process and projects.

FLUSH command explained

I want to know the use of the FLUSH command. How does it works, and where can we use this FLUSH? Like, "ALTER DATABASE FLUSH SHARED_POOL".

The FLUSH command here applies to a memory structure in an Oracle instance called the Shared Pool. This memory structure stores lots of information such as parsed SQL statements. If you issue the FLUSH SHARED_POOL command, you are forcing the contents of the Shared Pool to be wiped out (or washed down the drain). This can be useful if you suspect that the contents of the Shared Pool are fragmented or in need of a good house cleaning. But in the latest versions of Oracle, the database is doing a pretty good job of cleaning house on its own. So there really shouldn't be a need to issue this command except in the rarest of circumstances. If you do issue this command, your application(s) can suffer a performance hit until it reparses all SQL statements that used to be stored in the Shared Pool.

For More Information

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.