Hi all!

I have a query:

1.How should we tune SHARED_POOL_SIZE cache Hit ratio!
What should be the Percentage of cache Hit ratio for SHARED
pool.

Is there any particular select query for it!

2.Would deleting innumerable Trace files occupying unnecessary disk space create any impact on the Production/development Database!

3.Does configuring SHARED_POOL_SIZE automatically allocates required memory to Data Dictionary cache,Library Cache,Shared Sql Area!

Thanks&Regards,

Amitst.