Saturday, December 12, 2020

Pluggable database open and save

# 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

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/