Oracle Study之-Oracle 11g OCM考试（2)

时间：2016-04-15 来源：

11g OCM考试 纲:Server Configuration
1  Create the database
2  Determine and set sizing parameters for database structures
3  Create and manage temporary, permanent, and undo tablespaces
4  Stripe data files across multiple physical devices and locations

按照考试要求，配置表空间及控制文件、redo log的多元化

一、配置表空间

[oracle@rh64 ~]$ export ORACLE_SID=test1
[oracle@rh64 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 12 17:24:43 2016
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.
17:24:43 SYS@ test1>startup
ORACLE instance started.
Total System Global Area  313159680 bytes
Fixed Size                  2227944 bytes
Variable Size             218104088 bytes
Database Buffers           88080384 bytes
Redo Buffers                4747264 bytes
Database mounted.
Database opened.

1）配置Undo表空间

17:25:12 SYS@ test1>show parameter undo
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1
设置undo_retention参数，可以按照业务中事务最长的查询时间来设置：
17:25:47 SYS@ test1>alter system set undo_retention=3600;     
System altered.

17:26:14 SYS@ test1>show parameter undo;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     3600
undo_tablespace                      string      UNDOTBS1

创建Undo tablespace：
23:49:48 SYS@ test1>create undo tablespace undotbs2
23:49:55   2  datafile '/u01/app/oracle/oradata/test1/undotbs02.dbf' size 100m
23:50:01   3  autoextend on maxsize 2g
23:50:06   4  extent management local;
Tablespace created.

23:50:37 SYS@ test1>show parameter undo

-----------  OCM考试，后续陆续推出。。。