Database Memory & 4030/4031 (MOSC)

MOSC Banner

Steps to change SGA in 12C

edited Oct 12, 2015 10:00AM in Database Memory & 4030/4031 (MOSC) 1 commentAnswered

Hi,

I am very new to 12c.In our DB we enabled AMM .The DBA set memory parameters to 65G and mentioned SGA as 35G and PGA as 20G previously. We are having high db file sequential read and SGA starvation is observed.I was trying to set SGA to zero with alter command (following old 11g version method).But getting below  error.

SQL> alter system set sga_max_size=0 scope=spfile;

alter system set sga_max_size=0 scope=spfile

*

ERROR at line 1:

ORA-65040: operation not allowed from within a pluggable database

I wanted to see SPFILE contents too as below.Again same error.

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