oracle字符集的查询，进程说明

(1)查看库信息

select * from v$version

(2)查看字符集

select * from sys.props$ wherename='NLS_CHARACTERSET';

1． 进程查看

l 数据库写进程：oracle 2438 1 0 01:39 00:00:00 ora_dbw0_EDWPRD

l 日志写进程： oracle 2440 1 0 01:39 00:00:00 ora_lgwr_EDWPRD

l 监控进程： oracle 2432 1 0 01:39 00:00:00 ora_pmon_EDWPRD

l 检查点写进程：oracle 2442 1 0 01:39 00:00:00 ora_ckpt_EDWPRD

l 系统监控进程：oracle 2444 1 0 01:39 00:00:00 ora_smon_EDWPRD

l 恢复进程; oracle 2446 1 0 01:39 00:00:00 ora_reco_EDWPRD

2. 数据库的启动：

（1）从unmount 状态切换到 mount状态

sqlplus / as sysdba

SQL> startup nomount

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 2020224 bytes

Variable Size 113249408 bytes

Database Buffers 167772160 bytes

Redo Buffers 2170880 bytes

SQL> alter database edwprd mount;

（2）从read only 状态切换到read write

alter database edwprd open read only;

shutdown

startup mount

alter database edwprd open read write;