分析哪个表就用哪个用户做:下面的操作.
就用该用户:
1.先创建个表: chained_rows表
SQL> @?/rdbms/admin/utlchain
Table created.
脚本的定义:
$ ll utlchain*
-rw-r----- 1 oracle oinstall 1160 Jun 24 1998 utlchain.sql
$ more utlchain.sql
rem
rem $Header: utlchain.sql 07-may-96.19:40:01 sbasu Exp $
rem
Rem Copyright (c) 1990, 1995, 1996, 1998 by Oracle Corporation
Rem NAME
REM UTLCHAIN.SQL
Rem FUNCTION
Rem Creates the default table for storing the output of the
Rem analyze list chained rows command
Rem NOTES
Rem MODIFIED
Rem syeung 06/17/98 - add subpartition_name
Rem mmonajje 05/21/96 - Replace timestamp col name with analyze_timestam
Rem sbasu 05/07/96 - Remove echo setting
Rem ssamu 08/14/95 - merge PTI with Objects
Rem ssamu 07/24/95 - add field for partition name
Rem glumpkin 10/19/92 - Renamed from CHAINROW.SQL
Rem ggatlin 03/09/92 - add set echo on
Rem rlim 04/29/91 - change char to varchar2
Rem Klein 01/10/91 - add owner name for chained rows
Rem Klein 12/04/90 - Creation
Rem
create table CHAINED_ROWS (
owner_name varchar2(30),
table_name varchar2(30),
cluster_name varchar2(30),
partition_name varchar2(30),
subpartition_name varchar2(30),
head_rowid rowid,
analyze_timestamp date
);
SQL> analyze table ACT_INFO list chained rows;
Table analyzed.
SQL>select * from chained_rows WHERE table_name='ACT_INFO';
如果没有返回行,说明没有任何链化问题,如果存在了,就将返回所有的链化行的head_rowid.
在v$sysstat,table fetch continu8ed row 同样可以表示链化行。
为了避免链化问题,可以设定正确的pctfree来避免。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/119941/viewspace-705350/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/119941/viewspace-705350/