Experts ,
Please tell us , what is the best approach to check whether allocated SGA is adequate or NOT ?
Below error received by appl team , when they tried to execute simple SELECT SQL against v$database
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool"," select instance_name, status , .... ","sga heap (4,0)","kglsim object batch")
Product is SQL*Plus: Release 11.2.0.4.0