Home » SQL & PL/SQL » SQL & PL/SQL » shared pool
shared pool [message #37684] Wed, 20 February 2002 20:06 Go to next message
Messages: 141
Registered: October 1998
Senior Member
I suspect that the command
alter system flush shared_pool;
does not flush the cache completely. I found that a command which took 1.26 cpu seconds to service took only 0.44 seconds when i ran the same query after flushing the shared_pool. What should i do to ensure that the shared_pool is flushed completely. Do i have to shutdown and restart the database everytime i want to flush the shared pool? Please help.
Re: shared pool [message #37686 is a reply to message #37684] Wed, 20 February 2002 23:00 Go to previous message
Messages: 191
Registered: February 2002
Senior Member
i don't know how to check wheather the cache is fully refresh or not.
However, the execution time fo query is also affected by other few factor then cache . like
1. CPU/ OS usage on memory by other process
2. Oracle activities.
3. Network usage.
These factor might slow down the execution time of your command. Hope, this will help you
Previous Topic: Re: how to use audit command
Next Topic: Re: 'ORA-03123 - operation would block'
Goto Forum:

Current Time: Fri Sep 17 11:57:15 CDT 2021