Sql Area
Hi Experts,
I have some tuning issues on my Production database. i have set the memory_target is 6080M according to recommendation from tuning adviser and sga_target is 0 please find below out put of V$librarycache is there a need to increase the shared pool parameter.
NAMESPAC GETHITRATIO
SQL AREA, 0.672405317418054
TABLE/PROCEDURE, 0.99783606836426
BODY 0.99509705000062
TRIGGER, 0.996517173210251
INDEX, 0.918881508293226
CLUSTER, 0.993408159629432
OBJECT, 1
PIPE, 0.993246760074656
JAVA SOURCE, 1
JAVA RESOURCE, 0.0833333333333333
JAVA DATA, 0.999002493765586
Db: 11.1.0.7
Application: Oracle Ebs-R12(12.1.2)
OS: Oracle Linux5x86-64
looking forward.
Regards,
I have some tuning issues on my Production database. i have set the memory_target is 6080M according to recommendation from tuning adviser and sga_target is 0 please find below out put of V$librarycache is there a need to increase the shared pool parameter.
NAMESPAC GETHITRATIO
SQL AREA, 0.672405317418054
TABLE/PROCEDURE, 0.99783606836426
BODY 0.99509705000062
TRIGGER, 0.996517173210251
INDEX, 0.918881508293226
CLUSTER, 0.993408159629432
OBJECT, 1
PIPE, 0.993246760074656
JAVA SOURCE, 1
JAVA RESOURCE, 0.0833333333333333
JAVA DATA, 0.999002493765586
Db: 11.1.0.7
Application: Oracle Ebs-R12(12.1.2)
OS: Oracle Linux5x86-64
looking forward.
Regards,
0