专用服务器   1 client process----1 Server Process

共享服务器 N client Process----M Server Process   N>M   100 30

默认 专用服务器连接

Server 端设置

参数------参数文件 《References》

参数项目=参数值

show parameter 参数名

PROCESSES=150   （后台进程+server process）

alter system set PROCESSES=180 scope=spfile;

alter system set SHARED_SERVER_SESSIONS=400;

alter system set SHARED_SERVERS=50;

alter system set DISPATCHERS='(PROTOCOL=TCP)(DISPATCHERS=3)';

alter system set MAX_DISPATCHERS=5;

alter system set MAX_SHARED_SERVERS=60;

180

60-shared

20-30后台

90-100-dedicated

Client 端设置

Lesson 7

SQL> CREATE TABLESPACE TBS2 DATAFILE '+DATA' SIZE 50M;

Tablespace created.

SQL> CREATE TABLESPACE tbs3 DATAFILE '+DATA' SIZE 20M AUTOEXTEND ON NEXT 10M MAXSIZE 20G;（错误显示： cannot add file 'data' - file already part of database）

OMF

Tablespace created.

SQL> !mkdir -p /u01/app/oracle/oradata/orcl

SQL> CREATE TABLESPACE tbs4 DATAFILE '/u01/app/oracle/oradata/orcl/tbs4.dbf' SIZE 50M autoextend on;

Tablespace created.

SQL> create table t02 tablespace tbs4 as select * from sh.sales where rownum<100001;

Table created.

扩展表空间大小

1 增加尺寸

2 自动扩展

3 添加文件

 select tablespace_name,file_id,file_name from dba_data_files;

 ALTER DATABASE DATAFILE 7 resize 80M;

SQL> create table t03 tablespace tbs2 as select * from sh.sales;

Table created.

SQL> insert into t03 select * from t03;

 ALTER DATABASE DATAFILE 7 resize 80M;

ALTER DATABASE DATAFILE 7 autoextend on next 10M maxsize 30G;

ALTER TABLESPACE tbs2 ADD DATAFILE '+DG1' size 50M autoextend on;

drop tablespae tbs3;

drop tablespae tbs4 ；

DROP TABLESPACE tbs4 including contents and datafiles;

DROP TABLESPACE tbs2 INCLUDING CONTENTS;

ITPub博客

专用服务器-共享服务器

最新文章