Query and process description for Oracle Character set

(1) View library information

SELECT * FROM V$version

(2) View character set

SELECT * from sys.props$ wherename= ' Nls_characterset ';

1. Process View

L Database Write process: Oracle 2438 1 0 01:39? 00:00:00 ORA_DBW0_EDWPRD

L Log Write process: Oracle 2440 1 0 01:39? 00:00:00 ORA_LGWR_EDWPRD

• Monitoring process: Oracle 2432 1 0 01:39? 00:00:00 ORA_PMON_EDWPRD

• Checkpoint Write process: Oracle 2442 1 0 01:39? 00:00:00 ORA_CKPT_EDWPRD

L System Monitoring process: Oracle 2444 1 0 01:39? 00:00:00 ORA_SMON_EDWPRD

• recovery process;        Oracle 2446 1 0 01:39? 00:00:00 ORA_RECO_EDWPRD

2. Start of database:

(1) switch from Unmount state to Mount state

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) switch from Read only state to read write

ALTER DATABASE EDWPRD open read only;

Shutdown

Startup Mount

ALTER DATABASE EDWPRD Open read write;

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/