thanks for your immediate response, even though i set my shared_pool_size to 320Mb, its not working. My large_pool_size is 10MB. my DB version is 9.0.1.4.0, Do i need to set the parameter parallel_automatic_tuning=true in my init.ora? and what about the large_pool_size.

thanks