Thanks for the reply. So, setting the parameter ALLOW_GROUP_ACCESS_TO_SGA=TRUE is the only thing which need to done to provide access to SGA to users of Oracle owner group? If I set ALLOW_GROUP_ACCESS_TO_SGA=TRUE and try attaching to the shared memory segment with an os user that belongs to the dba group, would that work in Oracle 12c (18.104.22.168 in my case)?
Actually, in one of our env's we have done this, but still the Read access is not being granted to the DBA group. Please help!
Thanks & Regards