Thursday, April 18, 2013

Oracle clear TOP statistics

Because the statistics are stored in shared pool, flushing the shared pool will remove also these statistics. The drawback is that this flushing will also erase cached SQL's, procedures, functions, etc.

ALTER SYSTEM FLUSH SHARED POOL;

No comments:

Post a Comment