Database Tuning (MOSC)

MOSC Banner

Sql Area

edited Jan 21, 2014 5:21AM in Database Tuning (MOSC) 4 commentsAnswered
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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center