# check sga_max_size --size
# if sga less than 3000m then increase it between 4000-5000m
SHOW PARAMETER SGA;
ALTER SYSTEM SET MEMORY_TARGET =5000M SCOPE=SPFILE
# now shutdown, start & check
SHUT IMMEDIATE
STATUP
# check sga_max_size --size
SHOW PARAMETER SGA;
# check pluggable database
select name,open_mode from v$pdbs;
# if it is mounted then open it
ALTER PLUGGABLE DATABASE ORCLPDB OPEN;
# orclpdb is pluggable database this command for running database then pluggable database will start automatically
ALTER PLUGGABLE DATABASE ORCLPDB SAVE STATE;
No comments:
Post a Comment