High latches on SGA
Hi these are the latches that we have on our database platform is AIX and and the DB version is 10.2.0.5.0 - 64bit and the SGA is set to 1G
NAME GETS MISSES SLEEPS WAIT_TIME
-------------------------------------------------- ---------- ---------- ---------- ----------
KFMD SGA 12902716 356656 147237 5363474202
slave class create 1929533 5953 5877 292426006
shared pool 4045639188 25702505 14965 101822709
library cache 1.1544E+10 8343037 2810 44730354
query server process 143893 583 694 34749993
SQL memory manager latch 32182128 862792 2465 29134812
cache buffers chains 1.6884E+11 78605292 38645 27852148
row cache objects 9642193534 14485842 1263 26759743
library cache lock 1.3691E+10 4526169 977 17412611
redo allocation 346551721 181275 475 7432593
enqueues 1001666267 2134204 690 3506111
enqueue hash chains 1.2290E+10 879431 453 2421050
library cache pin 2333134002 545655 102 1842759
session allocation 200565918 2134437 1348 1834767
can increasing the SGA will reduce the number the waits on latches that are conserned with the SGA.
NAMESPACE GETS PINS RELOADS INVALIDATIONS
--------------- ---------- ---------- ---------- -------------
SQL AREA 1399538694 1067463020 29574592 7818482
TABLE/PROCEDURE 132286730 1092480902 40102343 0
BODY 1814663 84367912 1713919 0
TRIGGER 1241145 32501685 671669 0
INDEX 271656 813695 18911 0
CLUSTER 2538548 9390474 103155 0
OBJECT 0 0 0 0
PIPE 2 2 0 0
JAVA SOURCE 0 0 0 0
JAVA RESOURCE 1 1 0 0
JAVA DATA 5 527 0 0
most of the data in the library cache is reloaded i am thinking that increasing the size of the SGA will solve the issue.
any comments please......
please advice.