ORACLE 釋放表及其表空間測(cè)試

1.準(zhǔn)備--表空間使用率視圖創(chuàng)建

SQL>
 grant select on dba_free_space to test;
 grant select on dba_data_files to test;
 grant select on v_$temp_extent_pool to test;
 grant select on v_$temp_space_header to test;
 grant select on dba_temp_files to test;


create or replace view v_xag_tablespace_stat as
select tablespace_type,tablespace_name,autoext
       ,max_mb,used_mb,round(100 * used_mb / max_mb) pct_used
from
(
 select 'USER' as tablespace_type,a.tablespace_name as tablespace_name,autoext
       ,a.bytes_alloc - nvl(b.bytes_free, 0) as used_mb
       ,a.maxbytes as max_mb
 from
 (
   select f.tablespace_name,f.autoextensible as autoext
          ,trunc(sum(f.bytes)/power(2,20)) as bytes_alloc
          ,trunc(sum(decode(f.autoextensible,'YES',f.maxbytes,'NO',f.bytes))/power(2,20)) as  maxbytes
   from dba_data_files f
   group by tablespace_name,autoextensible
 ) a left join
 (
   select f.tablespace_name,trunc(sum(f.bytes)/power(2,20)) as bytes_free
   from dba_free_space f
   group by tablespace_name
 ) b on (a.tablespace_name=b.tablespace_name)
 union all
 select 'TEMP' as tablespace_type,h.tablespace_name as tablespace_name,f.autoextensible as autoext
       ,trunc(sum(nvl(p.bytes_used, 0)) / power(2, 20)) used_mb
       ,trunc(sum(decode(f.autoextensible,'YES',f.maxbytes,'NO',f.bytes))/power(2, 20)) max_mb
 from v$temp_space_header h left join v$temp_extent_pool p on(p.file_id=h.file_id and p.tablespace_name=h.tablespace_name)
     join dba_temp_files f on(f.file_id = h.file_id and f.tablespace_name = h.tablespace_name)
 group by h.tablespace_name,autoextensible
);

2.創(chuàng)建測(cè)試用途的表空間

--drop tablespace sp1 including contents and datafiles;

create tablespace sp1 datafile 
'/u02/oradata/MPCDB/MPTEST/sp1.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED
extent management local segment space management auto;

create tablespace i_sp1 datafile 
'/u02/oradata/MPCDB/MPTEST/i_sp1.dbf' size 16M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
extent management local segment space management auto;

create tablespace sp2 datafile 
'/u02/oradata/MPCDB/MPTEST/sp2.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED
extent management local segment space management auto;

create tablespace i_sp2 datafile 
'/u02/oradata/MPCDB/MPTEST/i_sp2.dbf' size 16M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
extent management local segment space management auto;

create tablespace sp3 datafile 
'/u02/oradata/MPCDB/MPTEST/sp3.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED
extent management local segment space management auto;

create tablespace i_sp3 datafile 
'/u02/oradata/MPCDB/MPTEST/i_sp3.dbf' size 16M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
extent management local segment space management auto;

3.檢查表空間使用率

[oracle@DB01 ~]$ sql TEST/123456@127.0.0.1:1521/MPTEST

SQL> SET SQLFORMAT ansiconsole

SQL> select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','I_SP1','I_SP2','I_SP3') order by 2;
-----------------------------------------------------------------------------------------------------
TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   1        0         
USER             I_SP2            YES      32767   1        0         
USER             I_SP3            YES      32767   1        0         
USER             SP1              YES      32767   1        0         
USER             SP2              YES      32767   1        0         
USER             SP3              YES      32767   1        0

4.創(chuàng)建測(cè)試表

create table tb1 tablespace sp1
as 
select rownum row_no,rpad('M',9,'A') || rownum ca,rpad('M',9,'B') cb,rpad('M',9,'C') cc from dual 
connect by level<=300000;

alter table tb1 add constraint pk_tb1 
primary key(row_no) using index tablespace i_sp1;

create index idx_tb1_01 on tb1(ca) tablespace i_sp1;

#用上面同樣方法創(chuàng)建 tb2椎眯、tb3 表

5.檢查空間使用情況

SQL> select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','I_SP1','I_SP2','I_SP3') order by 2;
TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   16       0         
USER             I_SP2            YES      32767   16       0         
USER             I_SP3            YES      32767   16       0         
USER             SP1              YES      32767   17       0         
USER             SP2              YES      32767   17       0         
USER             SP3              YES      32767   17       0  

--查看一個(gè)表所占的空間大小   
SQL> SELECT bytes/1024/1024 ||'MB' TABLE_SIZE ,u.segment_name,u.segment_type FROM USER_SEGMENTS U WHERE U.SEGMENT_NAME like '%TB%' order by 3,2;
TABLE_SIZE  SEGMENT_NAME  SEGMENT_TYPE  
9MB         IDX_TB1_01    INDEX         
9MB         IDX_TB2_01    INDEX         
9MB         IDX_TB3_01    INDEX         
6MB         PK_TB1        INDEX         
6MB         PK_TB2        INDEX         
6MB         PK_TB3        INDEX         
16MB        TB1           TABLE         
16MB        TB2           TABLE         
16MB        TB3           TABLE

6.刪除一半數(shù)據(jù)

delete from tb1 t where mod(row_no,2)=0; --刪除偶數(shù)
delete from tb2 t where mod(row_no,2)=0; --刪除偶數(shù)
delete from tb3 t where mod(row_no,2)=0; --刪除偶數(shù)
commit;

7.再次空間檢查（發(fā)現(xiàn)空間未見(jiàn)減少）

SQL> select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','I_SP1','I_SP2','I_SP3') order by 2;
TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   16       0         
USER             I_SP2            YES      32767   16       0         
USER             I_SP3            YES      32767   16       0         
USER             SP1              YES      32767   17       0         
USER             SP2              YES      32767   17       0         
USER             SP3              YES      32767   17       0  

--查看一個(gè)表所占的空間大小   
SQL> SELECT bytes/1024/1024 ||'MB' TABLE_SIZE ,u.segment_name,u.segment_type FROM USER_SEGMENTS U WHERE U.SEGMENT_NAME like '%TB%' order by 3,2;
TABLE_SIZE  SEGMENT_NAME  SEGMENT_TYPE  
9MB         IDX_TB1_01    INDEX         
9MB         IDX_TB2_01    INDEX         
9MB         IDX_TB3_01    INDEX         
6MB         PK_TB1        INDEX         
6MB         PK_TB2        INDEX         
6MB         PK_TB3        INDEX         
16MB        TB1           TABLE         
16MB        TB2           TABLE         
16MB        TB3           TABLE   

--檢查方法3
SELECT A.TABLESPACE_NAME,      
       FILENUM,   
       TOTAL "TOTAL (MB)",  
       F.FREE "FREE (MB)",
       TO_CHAR(ROUND(FREE * 100 / TOTAL, 2), '990.00') "FREE%", 
       TO_CHAR(ROUND((TOTAL - FREE) * 100 / TOTAL, 2), '990.00') "USED%",    
       ROUND(MAXSIZES, 2) "MAX (MB)"
  FROM (SELECT TABLESPACE_NAME,          
               COUNT(FILE_ID) FILENUM,        
               SUM(BYTES / (1024 * 1024)) TOTAL,          
               SUM(MAXBYTES) / 1024 / 1024 MAXSIZES      
          FROM DBA_DATA_FILES       
         GROUP BY TABLESPACE_NAME) A,     
       (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES / (1024 * 1024))) FREE     
          FROM DBA_FREE_SPACE      
         GROUP BY TABLESPACE_NAME) F
 WHERE A.TABLESPACE_NAME = F.TABLESPACE_NAME
 and A.TABLESPACE_NAME like '%SP%'
 order by 1;
------------------------------------------
TABLESPACE_NAME  FILENUM  TOTAL (MB)  FREE (MB)  FREE%    USED%    MAX (MB)  
SP1              1        32          15           46.88    53.13  32767.98  
SP2              1        32          15           46.88    53.13  32767.98  
SP3              1        32          15           46.88    53.13  32767.98

8.分析表（空間未見(jiàn)減少）

analyze table tb1 compute statistics; 
or
analyze table tb1 compute statistics for table for all indexes for all indexed columns;

說(shuō)明：
analyze table my_table compute statistics;  
等價(jià)于：
analyze table my_table compute statistics for table for all indexes for all columns;

SQL> 
SELECT bytes/1024/1024 ||'MB' TABLE_SIZE ,u.segment_name,u.segment_type FROM USER_SEGMENTS U WHERE U.SEGMENT_NAME like '%TB%' order by 3,2;
TABLE_SIZE  SEGMENT_NAME  SEGMENT_TYPE  
9MB         IDX_TB1_01    INDEX         
9MB         IDX_TB2_01    INDEX         
9MB         IDX_TB3_01    INDEX         
6MB         PK_TB1        INDEX         
6MB         PK_TB2        INDEX         
6MB         PK_TB3        INDEX         
16MB        TB1           TABLE         
16MB        TB2           TABLE         
16MB        TB3           TABLE

9.move （降低高水位） --案例1

優(yōu)點(diǎn)：可以移動(dòng)表到其他表空間潦闲，
在執(zhí)行命令時(shí) 不需要執(zhí)行alter table table_name enable row movement

缺點(diǎn)：表move 會(huì)導(dǎo)致表中的索引失效，要rebuild煌抒；同時(shí)表會(huì)產(chǎn)生行級(jí)鎖巫湘；
在此如果表中有LOB字段 時(shí)要用一下命令來(lái)實(shí)現(xiàn)表空間移動(dòng)：
alter table owner.table_name move tablespace tablespace_name lob (lob_column) store as lob segment  tablespace tablespace_name;
也可以單獨(dú)move lob装悲，index要rebuild

--不move到新空間
SQL> alter table tb1 move;

SQL> select index_name,table_name,tablespace_name,index_type,status  from dba_indexes  where table_owner='TEST' and status!='VALID';
INDEX_NAME  TABLE_NAME  TABLESPACE_NAME  INDEX_TYPE  STATUS    
PK_TB1      TB1         I_SP1            NORMAL      UNUSABLE  
IDX_TB1_01  TB1         I_SP1            NORMAL      UNUSABLE  

SQL> alter index PK_TB1 rebuild;
SQL> alter index IDX_TB1_01 rebuild;

SQL> select index_name,table_name,tablespace_name,index_type,status  from dba_indexes  where table_owner='TEST' and status!='VALID';

10.空間檢查（發(fā)現(xiàn)空間減少）

SQL> select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','I_SP1','I_SP2','I_SP3') order by 2;

TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   9        0         
USER             I_SP2            YES      32767   16       0         
USER             I_SP3            YES      32767   16       0         
USER             SP1              YES      32767   9        0         
USER             SP2              YES      32767   17       0         
USER             SP3              YES      32767   17       0  

--查看一個(gè)表所占的空間大小   
SQL> SELECT bytes/1024/1024 ||'MB' TABLE_SIZE ,u.segment_name,u.segment_type FROM USER_SEGMENTS U WHERE U.SEGMENT_NAME like '%TB%' order by 3,2;

TABLE_SIZE  SEGMENT_NAME  SEGMENT_TYPE  
5MB         IDX_TB1_01    INDEX         
9MB         IDX_TB2_01    INDEX         
9MB         IDX_TB3_01    INDEX         
3MB         PK_TB1        INDEX         
6MB         PK_TB2        INDEX         
6MB         PK_TB3        INDEX         
8MB         TB1           TABLE         
16MB        TB2           TABLE         
16MB        TB3           TABLE  

--檢查方法3
SELECT A.TABLESPACE_NAME,      
       FILENUM,   
       TOTAL "TOTAL (MB)",  
       F.FREE "FREE (MB)",
       TO_CHAR(ROUND(FREE * 100 / TOTAL, 2), '990.00') "FREE%", 
       TO_CHAR(ROUND((TOTAL - FREE) * 100 / TOTAL, 2), '990.00') "USED%",    
       ROUND(MAXSIZES, 2) "MAX (MB)"
  FROM (SELECT TABLESPACE_NAME,          
               COUNT(FILE_ID) FILENUM,        
               SUM(BYTES / (1024 * 1024)) TOTAL,          
               SUM(MAXBYTES) / 1024 / 1024 MAXSIZES      
          FROM DBA_DATA_FILES       
         GROUP BY TABLESPACE_NAME) A,     
       (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES / (1024 * 1024))) FREE     
          FROM DBA_FREE_SPACE      
         GROUP BY TABLESPACE_NAME) F
 WHERE A.TABLESPACE_NAME = F.TABLESPACE_NAME
 and A.TABLESPACE_NAME like '%SP%'
 order by 1;
------------------------------------------
TABLESPACE_NAME  FILENUM  TOTAL (MB)  FREE (MB)  FREE%    USED%    MAX (MB)  
I_SP1            1        16          7            43.75    56.25  32767.98  
SP1              1        32          23           71.88    28.13  32767.98  
SP2              1        32          15           46.88    53.13  32767.98  
SP3              1        32          15           46.88    53.13  32767.98

11.move （降低高水位） --案例2--移動(dòng)到新空間中

create tablespace sp2_new datafile 
'/u02/oradata/MPCDB/MPTEST/sp2_new.dbf' size 32M AUTOEXTEND ON NEXT 32M MAXSIZE UNLIMITED
extent management local segment space management auto;

create tablespace i_sp2_new datafile 
'/u02/oradata/MPCDB/MPTEST/i_sp2_new.dbf' size 16M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
extent management local segment space management auto;

alter index PK_ACC_MERCHANTACCOUNTDET_1 rebuild partition PD1812  TABLESPACE I_PD1812 logging;


SQL> alter table tb2 move tablespace sp2_new;       ---移動(dòng)表到其它表空間

SQL> select index_name,table_name,tablespace_name,index_type,status  from dba_indexes  where table_owner='TEST' and status!='VALID';
-----------------------------------------------------------------------------------------------------
INDEX_NAME  TABLE_NAME  TABLESPACE_NAME  INDEX_TYPE  STATUS    
PK_TB2      TB2         I_SP2            NORMAL      UNUSABLE  
IDX_TB2_01  TB2         I_SP2            NORMAL      UNUSABLE 

SQL> alter index PK_TB2 rebuild tablespace i_sp2_new; 
SQL> alter index IDX_TB2_01 rebuild tablespace i_sp2_new; 

SQL> select index_name,table_name,tablespace_name,index_type,status  from dba_indexes  where table_owner='TEST' and status!='VALID';

12.空間檢查（發(fā)現(xiàn)空間減少）

SQL> select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','SP2_NEW','I_SP1','I_SP2','I_SP3','I_SP2_NEW') order by 2;

TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   9        0         
USER             I_SP2            YES      32767   1        0         
USER             I_SP2_NEW        YES      32767   9        0         
USER             I_SP3            YES      32767   16       0         
USER             SP1              YES      32767   9        0         
USER             SP2              YES      32767   1        0         
USER             SP2_NEW          YES      32767   9        0         
USER             SP3              YES      32767   17       0 

--查看一個(gè)表所占的空間大小   
SQL> SELECT bytes/1024/1024 ||'MB' TABLE_SIZE ,u.segment_name,u.segment_type FROM USER_SEGMENTS U WHERE U.SEGMENT_NAME like '%TB%' order by 3,2;

TABLE_SIZE  SEGMENT_NAME  SEGMENT_TYPE  
5MB         IDX_TB1_01    INDEX         
5MB         IDX_TB2_01    INDEX         
9MB         IDX_TB3_01    INDEX         
3MB         PK_TB1        INDEX         
3MB         PK_TB2        INDEX         
6MB         PK_TB3        INDEX         
8MB         TB1           TABLE         
8MB         TB2           TABLE         
16MB        TB3           TABLE

13.收縮空間 shrink space （回收相應(yīng)的索引）

優(yōu)點(diǎn)：降低高水位時(shí)索引不會(huì)失效

缺點(diǎn)：不能將表移動(dòng)到其他表空間昏鹃；高水位降低效果沒(méi)有move明顯；
同時(shí)在執(zhí)行命令前要先執(zhí)行(alter table table_name enable row movement允許行移動(dòng))也會(huì)表會(huì)產(chǎn)生行級(jí)鎖诀诊，
shrink比move更耗費(fèi)cpu,產(chǎn)生很多current block這樣生成巨大的redo與undo 如果表中索引很少可以建議使用move降低高水位

alter table tb3 enable row movement;   --開(kāi)啟行遷移功能洞渤。

alter table tb3 shrink space cascade;  -- 調(diào)整HWM時(shí)將阻塞DML操作 ,收縮表并降低hwm，并且回收相應(yīng)的索引属瓣。

alter table tb3 disable row movement;   --關(guān)閉行遷移功能载迄。

14.空間檢查

SQL> SELECT bytes/1024/1024 ||'MB' TABLE_SIZE ,u.segment_name,u.segment_type FROM USER_SEGMENTS U WHERE U.SEGMENT_NAME like '%TB%' order by 3,2;
TABLE_SIZE  SEGMENT_NAME  SEGMENT_TYPE  
5MB         IDX_TB1_01    INDEX         
5MB         IDX_TB2_01    INDEX         
4.5625MB    IDX_TB3_01    INDEX         
3MB         PK_TB1        INDEX         
3MB         PK_TB2        INDEX         
2.625MB     PK_TB3        INDEX         
8MB         TB1           TABLE         
8MB         TB2           TABLE         
7.625MB     TB3           TABLE         

SQL>  select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','SP2_NEW','I_SP1','I_SP2','I_SP3','I_SP2_NEW') order by 2;
TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   9        0         
USER             I_SP2            YES      32767   1        0         
USER             I_SP2_NEW        YES      32767   9        0         
USER             I_SP3            YES      32767   9        0         
USER             SP1              YES      32767   9        0         
USER             SP2              YES      32767   1        0         
USER             SP2_NEW          YES      32767   9        0         
USER             SP3              YES      32767   9        0         

SQL> select index_name,table_name,tablespace_name,index_type,status  from dba_indexes  where table_owner='TEST' and status!='VALID';

no rows selected

15.改變數(shù)據(jù)文件所占空間大小(OS 上空間大小）

如果想改變數(shù)據(jù)文件所占空間大小可執(zhí)行如下語(yǔ)句：
alter database datafile 'filename' resize 8g重定義數(shù)據(jù)文件的大新胀堋（不能小于該數(shù)據(jù)文件已用空間的大谢っ痢）。

alter database datafile '/u02/oradata/MPCDB/MPTEST/sp3.dbf' resize 24M;
alter database datafile '/u02/oradata/MPCDB/MPTEST/i_sp3.dbf' resize 12M;

16.收縮空間 shrink space（不回收相應(yīng)的索引）

create table tb22 tablespace sp2
as 
select rownum row_no,rpad('M',9,'A') || rownum ca,rpad('M',9,'B') cb,rpad('M',9,'C') cc from dual 
connect by level<=300000;

alter table tb22 add constraint pk_tb22
primary key(row_no) using index tablespace i_sp2;

create index idx_tb22_01 on tb22(ca) tablespace i_sp2;

delete from tb22 t where mod(row_no,2)=0; --刪除偶數(shù)
commit;

SQL>  select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','SP2_NEW','I_SP1','I_SP2','I_SP3','I_SP2_NEW') order by 2;
TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   9        0         
USER             I_SP2            YES      32767   16       0         
USER             I_SP2_NEW        YES      32767   9        0         
USER             I_SP3            YES      32767   9        0         
USER             SP1              YES      32767   9        0         
USER             SP2              YES      32767   17       0         
USER             SP2_NEW          YES      32767   9        0         
USER             SP3              YES      32767   9        0 

alter table tb22 enable row movement;   --開(kāi)啟行遷移功能粗截。
alter table tb22 shrink space; --( 調(diào)整HWM時(shí)將阻塞DML操作),收縮表捏卓，并且降低hwm
alter table tb22 disable row movement;   --關(guān)閉行遷移功能。

--索引未收縮
SQL>  select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','SP2_NEW','I_SP1','I_SP2','I_SP3','I_SP2_NEW') order by 2;
TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   9        0         
USER             I_SP2            YES      32767   16       0         
USER             I_SP2_NEW        YES      32767   9        0         
USER             I_SP3            YES      32767   9        0         
USER             SP1              YES      32767   9        0         
USER             SP2              YES      32767   9        0         
USER             SP2_NEW          YES      32767   9        0         
USER             SP3              YES      32767   9        0 

--收縮索引shrink space （不回收相應(yīng)的索引）
alter index pk_tb22 shrink space;
alter index idx_tb22_01 shrink space;

SQL>  select * from v_xag_tablespace_stat t where t.tablespace_name in('SP1','SP2','SP3','SP2_NEW','I_SP1','I_SP2','I_SP3','I_SP2_NEW') order by 2;
TABLESPACE_TYPE  TABLESPACE_NAME  AUTOEXT  MAX_MB  USED_MB  PCT_USED  
USER             I_SP1            YES      32767   9        0         
USER             I_SP2            YES      32767   9        0         
USER             I_SP2_NEW        YES      32767   9        0         
USER             I_SP3            YES      32767   9        0         
USER             SP1              YES      32767   9        0         
USER             SP2              YES      32767   9        0         
USER             SP2_NEW          YES      32767   9        0         
USER             SP3              YES      32767   9        0

最后編輯于：2020.11.16 15:26:20

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請(qǐng)聯(lián)系作者

人面猴
序言：七十年代末慈格，一起剝皮案震驚了整個(gè)濱河市怠晴，隨后出現(xiàn)的幾起案子，更是在濱河造成了極大的恐慌浴捆，老刑警劉巖蒜田，帶你破解...
沈念sama閱讀 221,695評(píng)論 6贊 515
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件，死亡現(xiàn)場(chǎng)離奇詭異选泻，居然都是意外死亡冲粤，警方通過(guò)查閱死者的電腦和手機(jī)，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 94,569評(píng)論 3贊 399
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進(jìn)店門页眯，熙熙樓的掌柜王于貴愁眉苦臉地迎上來(lái)梯捕，“玉大人，你說(shuō)我怎么就攤上這事窝撵】耍” “怎么了？”我有些...
開(kāi)封第一講書人閱讀 168,130評(píng)論 0贊 360
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵碌奉，是天一觀的道長(zhǎng)短曾。經(jīng)常有香客問(wèn)我，道長(zhǎng)赐劣，這世上最難降的妖魔是什么嫉拐？我笑而不...
開(kāi)封第一講書人閱讀 59,648評(píng)論 1贊 297
?港島之戀（遺憾婚禮）
正文為了忘掉前任，我火速辦了婚禮魁兼，結(jié)果婚禮上婉徘，老公的妹妹穿的比我還像新娘。我一直安慰自己，他們只是感情好盖呼，可當(dāng)我...
茶點(diǎn)故事閱讀 68,655評(píng)論 6贊 397
惡毒庶女頂嫁案：這布局不是一般人想出來(lái)的
文/花漫我一把揭開(kāi)白布儒鹿。她就那樣靜靜地躺著，像睡著了一般塌计。火紅的嫁衣襯著肌膚如雪挺身。梳的紋絲不亂的頭發(fā)上侯谁，一...
開(kāi)封第一講書人閱讀 52,268評(píng)論 1贊 309
城市分裂傳說(shuō)
那天锌仅，我揣著相機(jī)與錄音，去河邊找鬼墙贱。笑死热芹，一個(gè)胖子當(dāng)著我的面吹牛，可吹牛的內(nèi)容都是我干的惨撇。我是一名探鬼主播伊脓，決...
沈念sama閱讀 40,835評(píng)論 3贊 421
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開(kāi)眼，長(zhǎng)吁一口氣：“原來(lái)是場(chǎng)噩夢(mèng)啊……” “哼魁衙！你這毒婦竟也來(lái)了报腔？” 一聲冷哼從身側(cè)響起，我...
開(kāi)封第一講書人閱讀 39,740評(píng)論 0贊 276
萬(wàn)榮殺人案實(shí)錄
序言：老撾萬(wàn)榮一對(duì)情侶失蹤剖淀，失蹤者是張志新（化名）和其女友劉穎纯蛾，沒(méi)想到半個(gè)月后，有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體纵隔，經(jīng)...
沈念sama閱讀 46,286評(píng)論 1贊 318
?護(hù)林員之死
正文獨(dú)居荒郊野嶺守林人離奇死亡翻诉，尸身上長(zhǎng)有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點(diǎn)故事閱讀 38,375評(píng)論 3贊 340
?白月光啟示錄
正文我和宋清朗相戀三年，在試婚紗的時(shí)候發(fā)現(xiàn)自己被綠了捌刮。大學(xué)時(shí)的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片碰煌。...
茶點(diǎn)故事閱讀 40,505評(píng)論 1贊 352
活死人
序言：一個(gè)原本活蹦亂跳的男人離奇死亡，死狀恐怖绅作，靈堂內(nèi)的尸體忽然破棺而出芦圾，到底是詐尸還是另有隱情，我是刑警寧澤俄认，帶...
沈念sama閱讀 36,185評(píng)論 5贊 350
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布堕扶，位于F島的核電站，受9級(jí)特大地震影響梭依，放射性物質(zhì)發(fā)生泄漏稍算。R本人自食惡果不足惜，卻給世界環(huán)境...
茶點(diǎn)故事閱讀 41,873評(píng)論 3贊 333
男人毒藥：我在死后第九天來(lái)索命
文/蒙蒙一役拴、第九天我趴在偏房一處隱蔽的房頂上張望糊探。院中可真熱鬧，春花似錦、人聲如沸科平。這莊子的主人今日做“春日...
開(kāi)封第一講書人閱讀 32,357評(píng)論 0贊 24
一樁弒父案，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽(yáng)瞪慧。三九已至髓考，卻和暖如春，著一層夾襖步出監(jiān)牢的瞬間弃酌，已是汗流浹背氨菇。一陣腳步聲響...
開(kāi)封第一講書人閱讀 33,466評(píng)論 1贊 272
情欲美人皮
我被黑心中介騙來(lái)泰國(guó)打工，沒(méi)想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留妓湘，地道東北人查蓉。一個(gè)月前我還...
沈念sama閱讀 48,921評(píng)論 3贊 376
代替公主和親
正文我出身青樓，卻偏偏與公主長(zhǎng)得像榜贴，于是被迫代替她去往敵國(guó)和親豌研。傳聞我的和親對(duì)象是個(gè)殘疾皇子，可洞房花燭夜當(dāng)晚...
茶點(diǎn)故事閱讀 45,515評(píng)論 2贊 359

ORACLE 釋放表及其表空間測(cè)試

推薦閱讀更多精彩內(nèi)容