Technology Exchange
免费咨询热线
400-090-9964
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考试,后续陆续推出。。。