| shared pool [message #37684] |
Wed, 20 February 2002 20:06  |
krishna
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  |
seng
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
