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;
ALTER SYSTEM FLUSH SHARED POOL;
No comments:
Post a Comment