课程第45/46次（2017-02-12星期日上下午）

botang · 发表于 2017-2-12 22:20:28

上完1Z0-053第08章（RMAN Tuning）
上完1Z0-052第07章（Tablespace）
（052共19章，053共21章，063多租户共9章，49-29）

关于此片子的解释：

Each file need at least 4 buffers!

DISK Read(Backup/Restore)

Max4files_16Mchannel
1. buffer=1Mbuffer
2. 1file=16*1Mbuffer
   2files=8*1Mbuffer+8*1Mbuffer
   3files=8*1Mbuffer+4*1Mbuffer+4*1Mbuffer
   4files=4*1Mbuffer+4*1Mbuffer+4*1Mbuffer+4*1Mbuffer

5-Max8files_less16Mchannel
1. buffer=512Kbuffer
2. 5files=5*4*512Kbuffer=10Mchannel
3. 6files=6*4*512Kbuffer=12Mchannel
4. 7files=7*4*512Kbuffer=14Mchannel
5. 8files=8*4*512Kbuffer=16Mchannel

8+files
1. buffer=128Kbuffer
2. 9files=9*4*128Kbuffer=4.5Mchannel
3. 16files=16*4*128Kbuffer=8Mchannel

关于异步IO：

SELECT s.sid, p.spid, s.client_info
FROM v$process p, v$session s
WHERE p.addr = s.paddr
AND CLIENT_INFO LIKE '%XXXX%';
SELECT s.sid, p.spid, s.client_info
FROM v$process p, v$session s
WHERE p.addr = s.paddr
and s.program like '%rman%';
select * from v_$backup_async_io a;
select * from v_$backup_sync_io s;

复制代码

关于duration：

RMAN> backup duration 00:05 minimize load tablespace example ;

复制代码

关于表空间：

select * from v$version;
select t.TABLE_NAME, t.PCT_FREE,
t.PCT_USED,
t.INI_TRANS
from dba_tables t
where t.OWNER='HR' and t.TABLE_NAME in ('EMPLOYEES',
'EMP2',
'T05207_A');
select i.INDEX_NAME,
i.PCT_FREE,
i.INI_TRANS
from dba_indexes i
where i.TABLE_OWNER='HR' and
i.TABLE_NAME='T05207_A';
select * from dba_tablespaces;
create tablespace tbs05207_m
datafile '/u01/app/oracle/oradata/orcl/tbs05207_m.dbf' size 5M
segment space management manual;
---
select * from dba_extents e
where e.OWNER='HR' and e.SEGMENT_NAME='T05207_A';
select * from dba_segments s
where s.OWNER='HR' and s.SEGMENT_NAME='T05207_A';
select * from dba_segments s
where s.OWNER='HR' and s.SEGMENT_NAME='I05207_A';
---
select * from dba_extents e
where e.OWNER='HR' and e.SEGMENT_NAME='T04209_UNAME';
----
select sum(bytes)/1024/1024
from dba_data_files df
where df.TABLESPACE_NAME='SYSTEM';
----
select sum(bytes)/1024/1024
from dba_free_space fs
where fs.TABLESPACE_NAME='SYSTEM';
---
select sum(bytes)/1024/1024
from dba_data_files df
where df.TABLESPACE_NAME='UNDOTBS1';
select sum(bytes)/1024/1024
from dba_undo_extents ue
where ue.STATUS<>'EXPIRED';
---
select sum(bytes)/1024/1024
from dba_temp_files df
where df.TABLESPACE_NAME='TEMP';
--
select (t.bytes_used)/1024/1024
from V$TEMP_EXTENT_POOL t;
---

复制代码