400-090-9964


博客 | 论坛

教学文章

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考试,后续陆续推出。。。

版权所有@北京神脑资讯技术有限公司(CUUG,中国UNIX用户协会) Copyright 2017 ALL Rights Reserved 京ICP备11008061号 京公网110108006275号

CUUG旗下网站:www.cuug.com.cn www.cuug.com oracle.cuug.com bbs.cuug.com blog.cuug.com

电话:010-59426307 010-59426319 mail:cuug_bj@cuug.com

邮政编码:100089 地址:北京市海淀区紫竹院路88号紫竹花园4号楼D座703(CUUG)