-
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.
-
Q(1)
read metalink doc 16347.1
Q(2)
if auto extend is on for ur tablespaces and they are acquiring space as and when required and the datafile resides on the same drive/volume where the junk trace is growing relentlessly u shall have a fragmented tablespace impacting performance as many pieces are to be accessed on the disk.
Q(3)
yes
