课程第45次：2016-07-08星期五

botang · 发表于 2016-7-9 11:10:22

本帖最后由 botang 于 2016-7-9 11:15 编辑

【上完1Z0-051的第11章，上完1Z0-051】其他Oracle Schema对象
【开始1Z0-052的第7章】表空间
【上完1Z0-051】：共12章（0 1 2 3 4 5 6 7 8 9 10 11）
【1Z0-052】：共13章（0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18）
【1Z0-053】：共15章（0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20）
表示已经上过的，表示还没上的。
完全按照上课顺序：
https://www.botangdb.com/mytrain/201601/00000028.html

1Z0-051.txt：

select * from user_sequences ;
select * from dba_Tables t where t.table_name ='SEQ$‘;
select * from seq$;
select * from dba_objects o where o.object_id=80574;
select * from dba_indexes i where i.blevel>1;
----
select * from user_indexes;
alter index DEPT_ID_PK rebuild online;
---
select * from user_synonyms;

复制代码

tablespace.sql：

create tablespace tbs05207_m datafile size 5M
segment space management manual;
create tablespace tbs05207_a datafile size 5M
segment space management auto;
select * from dba_tablespaces t where t.tablespace_name like 'TBS05207_%';
select * from dba_Tables t where t.owner='HR' and t.table_name like 'T05207%';
select i.pct_free, i.ini_trans
from dba_indexes i where i.owner='HR' and i.index_name='I05207_A3';
create bigfile tablespace tbs05207_big datafile size 5M autoextend on
maxsize 4T ;
select * from dba_tablespaces t where t.tablespace_name
in ( 'USERS','TBS05207_UNIFORM' , 'TEMP');
select * from dba_extents e where e.owner='HR'
and e.segment_name='T04209_UNAME';
----
create temporary tablespace temp2 tempfile size 5M
;
create tablespace tbs05207_uniform datafile size 5M
uniform size 512K;
----
select * from dba_tablespaces t where t.tablespace_name
in ( 'USERS','TBS05207_UNIFORM' , 'TEMP' , 'TEMP2');
---
select
( (select sum(bytes)
from dba_data_files df where df.tablespace_name='USERS')-
(select sum(bytes)
from dba_free_space fs where fs.tablespace_name='USERS')
)
/ ( select sum(bytes)
from dba_data_files df where df.tablespace_name='USERS')
from dual;
select sum(bytes)
from dba_free_space fs where fs.tablespace_name='USERS';
alter database datafile 4 resize 20M ;
----------------
select t.BYTES_USED
from v_$temp_extent_pool t;
select sum(bytes)
from dba_temp_files where tablespace_name='TEMP' ;
select sum(bytes)/1024/1024
from dba_data_files df where df.tablespace_name='UNDOTBS1';
select sum(ue.bytes)/1024/1024
from dba_undo_extents ue
where ue.status <> 'EXPIRED';

复制代码