Hi all!

Working on Oracle v8i 8.1.6.0.0 with OS as NT!

Query:

1.What is the significance and impact of the following command on DB:

ALTER SYSTEM FLUSH SHARED POOL;

In order to clean the SHARED SQL AREA in the LIBRARY CACHE,is the above command useful and does it clean all the components of Shared_pool!

Thanks & Regards,

Amit.