> 
> What does the following command do, and when should it be use.
> I am running Oracle 7.4 on NT.
> 
> ALTER SYSTEM FLUSH SHARED POOL.
> 
> 
> Thank You Very Much
> 
This will "flush" out, or clear, all SQL statements that are in the
Shared Pool Area. Oracle keeps track of each SQL statement that users execute.
It is stored parsed in memory so that if a SQL statement already has been
executed then Oracle does not need to re-parse it. The exception is if the
shared pool area is not large enough, then the least recently used SQL 
statements (except for pinned packages) will be removed from memory.

By flushing the shared pool, all SQL statements are removed from memory.


-Ari Kaplan
> 
> What does the following command do, and when should it be use.
> I am running Oracle 7.4 on NT.
> 
> ALTER SYSTEM FLUSH SHARED POOL.
> 
> 
> Thank You Very Much
> 

Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ck to Ari Kaplan's Home Page