oracle的高水位和低水位实验,oracle 高水位线及如何有效的降低高水位线

--exp/imp降低高水位线

[oracle@vedeu ~]$ exp vast/vast file=/home/oracle/ote.dmp tables=ote log=ote.log

Export: Release 11.2.0.3.0 - Production on Mon Jan 23 11:54:49 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...

. . exporting table OTE 29678rows exported

EXP-00091: Exporting questionable statistics.

EXP-00091: Exporting questionable statistics.

Export terminated successfully with warnings.

--删除ote表

VAST@prod > drop table ote purge;

Table dropped.

--导入表

[oracle@vedeu ~]$ imp vast/vast file=/home/oracle/ote.dmp full=y

Import: Release 11.2.0.3.0 - Production on Mon Jan 23 11:56:23 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.02.00 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

. importing VAST's objects into VAST

. importing VAST's objects into VAST

. . importing table "OTE" 29678 rows imported

Import terminated successfully without warnings.

--收集统计信息

VAST@prod > analyze table ote compute statistics;

Table analyzed.

--段的信息

VAST@prod > select bytes/1048576,blocks,extents from dba_segments where segment_name='OTE';

BYTES/1048576 BLOCKS     EXTENTS

------------- ---------- ----------

4         512         19

--分析表块数，空闲块数，行数

VAST@prod > SELECT blocks, empty_blocks, num_rows

2 FROM user_tables

3 WHERE table_name ='OTE';

BLOCKS EMPTY_BLOCKS NUM_ROWS

---------- ------------ ----------

496           16      29678

--检查索引以及同义词是否可用

VAST@prod > col name for a15;

VAST@prod > select 'INDEX' type,index_name name,status from dba_indexeswhere index_name='IND_OTE_ID'

2 union all

3 select'SYNONYM',object_name,status fromuser_objects whereobject_name='IND_OTE_ID';

TYPE    NAME            STATUS

------- --------------- --------

INDEX   IND_OTE_ID      VALID

SYNONYM IND_OTE_ID      VALID