Dear Readers,

Thank's to everyone for contributing on my query.

1) Now what's the difference between Shared_pool_size and Shared_pool_reserved_size. Is it deallocating memory ?

2) What are all the other methods of resolving HWM if available, other than truncating and droping the table and importing the table dump.

3) Is there a site address to OCP papers.

Thanks MANI PS