Oracle重启监听、修改内存

#常用 sqlplus登录

su - oracle
sqlplus / as sysdba   //用系统用户登录，不用密码
sqlplus census/oracle@172.16.100.200/GXSNERP

#常用1. 查看当前连接数：

sqlplus / as sysdba
SQL> select count(*) from v$process;

  COUNT(*)
----------
       196

#常用2. 重启监听

su oracle

1. 然后启动监听器 
lsnrctl start 
2. 会看到启动成功的界面;

3. 停止监听器命令.
lsnrctl stop 

4. 查看监听器命令:
lsnrctl status 

#常用3. 修改内存，6G -> 20G

1.直接dba 修改
alter system set sga_max_size=20G scope=spfile;

2.查看当前是否生效，<未生效，需要重启>

SQL> show parameter sga

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga	     boolean	 FALSE
lock_sga			     boolean	 FALSE
pre_page_sga			     boolean	 TRUE
sga_max_size			     big integer 6000M
sga_min_size			     big integer 0
sga_target			     big integer 6000M
unified_audit_sga_queue_size	     integer	 1048576

3.重启

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

4.重启之后再看<20G是已经生效了>：

SQL> show parameter sga

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga	     boolean	 FALSE
lock_sga			     boolean	 FALSE
pre_page_sga			     boolean	 TRUE
sga_max_size			     big integer 20G
sga_min_size			     big integer 0
sga_target			     big integer 20G
unified_audit_sga_queue_size	     integer	 1048576