– 查询
show parameter processes;
show parameter sessions;
show parameter open_cursors;
show parameter AQ_TM_PROCESSES;
show parameter deferred_segment_creation;
show parameter cursors;
– 参数修改
ALTER system SET aq_tm_processes = 1 scope = both;
ALTER system SET deferred_segment_creation = false scope = spfile;
alter system set processes=1000 scope=spfile;
alter system set open_cursors=1000 scope=both;
– UNDOTBS01表空间大小修改
alter database datafile ‘D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF’ resize 30720M;
– TEMP01表空间修改
ALTER DATABASE TEMPFILE ‘D:\APP\ADMINISTRATOR\ORADATA\ORCL\TEMP01.DBF’ RESIZE 30720M;
– 查看db_recovery_file_dest_size参数
show parameter db_recovery_file_dest_size;
– 重新设置db_recovery_file_dest_size参数
alter system set db_recovery_file_dest_size=10G scope=both;
– 重启
shutdown immediate
startup
