-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|