RAC上线操作

最新推荐文章于 2024-09-15 08:03:51 发布
最新推荐文章于 2024-09-15 08:03:51 发布
阅读量156 收藏
点赞数
文章标签： 数据库

oracle_grant_privileges

SET SERVEROUTPUT ON;
conn platform_b2b/kingdee
SET SERVEROUTPUT ON;
show user;

grant select,delete,insert,update on T_CORPORATION_BULLETIN to platform_dev;
grant select,delete,insert,update on T_CORPORATION_BUSINESS_CARD to platform_dev;
grant select,delete,insert,update on T_CORPORATION_CERTIFICATE to platform_dev;
grant select,delete,insert,update on T_CORPORATION_KEYWORD to platform_dev;
grant select,delete,insert,update on T_CORPORATION_LINKAGE to platform_dev;
grant select,delete,insert,update on T_CORPORATION_MOBILE_KEYWORD to platform_dev;
grant select,delete,insert,update on T_CORPORATION_PRODUCT to platform_dev;
grant select,delete,insert,update on T_CORPORATION_RANK_IN_CATALOG to platform_dev;
grant select,delete,insert,update on T_CORPORATION_RECOMMEND to platform_dev;
grant select,delete,insert,update on T_CORPORATION_SERVICE_SCOPE to platform_dev;
grant select,delete,insert,update on T_CORPORATION_STYLE. to platform_dev;
grant select,delete,insert,update on T_CORPORATION_TRADE to platform_dev;
grant select,delete,insert,update on T_DOMAIN_NAME to platform_dev;
grant select,delete,insert,update on T_FAVORITE to platform_dev;
grant select,delete,insert,update on T_PRODUCT to platform_dev;
grant select,delete,insert,update on T_PRODUCT_TYPE to platform_dev;
grant select,delete,insert,update on T_RECOMMEND_INFO to platform_dev;
grant select,delete,insert,update on T_PROVIDING_ESSENTIAL to platform_dev;
grant select,delete,insert,update on T_PURCHASE_INFO to platform_dev;
grant select,delete,insert,update on T_PROVIDING_DETAIL to platform_dev;
grant select,delete,insert,update on T_PROVIDING_DESC to platform_dev;
grant select,delete,insert,update on T_PUBLISH_TASKS to platform_dev;
grant select,delete,insert,update on T_RECOMMEND_COMPANY to platform_dev;
grant select,delete,insert,update on T_SEARCH_LOGS to platform_dev;
grant select,delete,insert,update on T_CATALOG to platform_dev;
grant select,delete,insert,update on T_CATALOG_HOT to platform_dev;
grant select,delete,insert,update on T_GL_CASE to platform_dev;
grant select,delete,insert,update on T_GL_MESSAGE to platform_dev;
grant select,delete,insert,update on T_GL_TEAM to platform_dev;
grant select,delete,insert,update on T_GL_RECOMMEND_INFO to platform_dev;
grant select,delete,insert,update on T_GL_PERSON_EDUCATION_HISTORY to platform_dev;
grant select,delete,insert,update on T_GL_PERSON_WORK_HISTORY to platform_dev;
grant select,delete,insert,update on T_GL_PRODUCT to platform_dev;
grant select,delete,insert,update on T_OPERATION_LOG to platform_dev;
grant select,delete,insert,update on T_SYS_EVENTLOG to platform_dev;

oracle建表空间、用户与数据迁移

一、建立表空间

（一）、创建PLATFORM_B2B表空间
CREATE TABLESPACE PLATFORM_B2B DATAFILE
  '+DATA1/authserv/datafile/PLATFORM_B2B.DBF' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED,
  '+DATA1/authserv/datafile/PLATFORM_B2B2.DBF' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED,
  '+DATA1/authserv/datafile/PLATFORM_B2B3.DBF' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED,
  '+DATA1/authserv/datafile/PLATFORM_B2B4.DBF' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

（二）、创建PLATFORM_DEV表空间
CREATE TABLESPACE PLATFORM_DEV DATAFILE
  '+DATA1/authserv/datafile/PLATFORM_DEV.DBF' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED,
  '+DATA1/authserv/datafile/PLATFORM_DEV2.DBF' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED,
  '+DATA1/authserv/datafile/PLATFORM_DEV3.DBF' SIZE 500M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

（三）、创建PLATFORM_BAK表空间
CREATE TABLESPACE PLATFORM_BAK DATAFILE
  '+DATA1/authserv/datafile/PLATFORM_BAK.DBF' SIZE 300M AUTOEXTEND ON NEXT 30M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;


二、建立用户并简单授权（更多的对象授权见oracle_grant_privileges.sql文件，等数据迁移完再执行）

（一）、创建PLATFORM_DEV用户
create user PLATFORM_DEV identified by kingdee;
grant CONNECT,RESOURCE,CREATE VIEW,CREATE JOB to PLATFORM_DEV ;
alter user PLATFORM_DEV default tablespace PLATFORM_DEV ;
grant create any table to platform_dev;
grant insert any table to platform_dev;
grant select any table to platform_dev;
grant CREATE ANY SYNONYM to platform_dev;

（二）、创建PLATFORM_B2B用户
create user PLATFORM_B2B identified by kingdee;
grant CONNECT,RESOURCE,CREATE VIEW,CREATE JOB to PLATFORM_B2B ;
alter user PLATFORM_B2B default tablespace PLATFORM_B2B ;

（三）、创建PLATFORM_BAK用户
create user PLATFORM_BAK identified by kingdee;
grant CONNECT,RESOURCE,CREATE VIEW,CREATE JOB to PLATFORM_BAK ;
alter user PLATFORM_BAK default tablespace PLATFORM_BAK ;

 

三、oracle数据迁移

（0）、首先停止40.107机器上的虚拟IP 40.7。

（一）、数据导出
（A）、生产环境数据导出
expdp system/kingdee directory=impdir dumpfile=dump_authserv_for_rac.dmp schemas=PLATFORM_DEV,PLATFORM_B2B,PLATFORM_BAK exclude=statistics logfile=dump_authserv_for_rac.log

（二）、数据导入(模拟环境24分50秒（DS3400））
（A）、生产环境
impdp system/kingdee directory=impdir dumpfile=dump_authserv_for_rac.dmp schemas=PLATFORM_DEV,PLATFORM_B2B,PLATFORM_BAK logfile=impdp_authserv_for_rac.log


（三）、执行对象授权脚本
oracle_grant_privileges.sql


（四）、计算统计信息
table_statistics.sql


四、mysql数据迁移
（一）、数据导出
/usr/local/mysql/bin/mysqldump -uroot -p -R --master-data=2 --single-transaction --databases mysql youshangportal ysproject zhuhaib2b zhuzhoub2b anyangb2b luoheb2b > /tmp/mysqlbak_for_rac.sql

（二）、数据导入（模拟平台恢复5分钟（X3550本地磁盘））
/usr/local/mysql/bin/mysql -uroot -p mysql> flush privileges;

table_statistics

SET SERVEROUTPUT ON;
conn system/kingdee
SET SERVEROUTPUT ON;
show user;


exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ACCESS_CERTIFICATE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ACCESS_CERTIFICATE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ACCESS_ROLE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ACCESS_ROLE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_AGENCY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_AGENCY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ASSOCIATE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ASSOCIATE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ASSOCIATE_ASSIGNED');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ASSOCIATE_ASSIGNED',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_AUTHPICTURE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_AUTHPICTURE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_BACKGROUND_OPERATION_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_BACKGROUND_OPERATION_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_BANK_TRANSFER_BILL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_BANK_TRANSFER_BILL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_BANK_TRANSFER_BILL_ORDERNUM');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_BANK_TRANSFER_BILL_ORDERNUM',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_BASIC_ACCOUNT_IMAGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_BASIC_ACCOUNT_IMAGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_BIZAREA');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_BIZAREA',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_BIZ_INFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_BIZ_INFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CERT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CERT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CITY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CITY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CITY_NEW');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CITY_NEW',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_COMMON_SEQUENCE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_COMMON_SEQUENCE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_COMM_CALLED_PARTY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_COMM_CALLED_PARTY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_COMM_COMMUNICATION_ACCOUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_COMM_COMMUNICATION_ACCOUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_COMM_ERROR_MESSAGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_COMM_ERROR_MESSAGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_COMM_FREE_ACOUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_COMM_FREE_ACOUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_COMM_SMS_MESSAGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_COMM_SMS_MESSAGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_COMM_USER_BINDING');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_COMM_USER_BINDING',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CONNECT_TABLE_FOR_C3P0');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CONNECT_TABLE_FOR_C3P0',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CONTRACT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CONTRACT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CORPORATION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CORPORATION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CORPORATION_USER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CORPORATION_USER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CORP_JOIN_PWD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CORP_JOIN_PWD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CORP_MOBILE_BUSINESS_CARD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CORP_MOBILE_BUSINESS_CARD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CORP_PARTNER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CORP_PARTNER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CORP_SERVICE_CHARACTER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CORP_SERVICE_CHARACTER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_CORP_STATE_CHANGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_CORP_STATE_CHANGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_DATEJOIN_TEMP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_DATEJOIN_TEMP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_DEALER_INVITATION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_DEALER_INVITATION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_DEALER_INVITATION_MAIL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_DEALER_INVITATION_MAIL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_DEPARTMENT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_DEPARTMENT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_DISTRI_CUSTOM_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_DISTRI_CUSTOM_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEDERATION_CORPORATION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEDERATION_CORPORATION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEDERATION_UNBIND_INFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEDERATION_UNBIND_INFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEDERATION_USER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEDERATION_USER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEDERATION_USER_LINKSUSER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEDERATION_USER_LINKSUSER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEE_ACCOUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEE_ACCOUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEE_ACCOUNT_NEW');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEE_ACCOUNT_NEW',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEE_ACCOUNT_OPERATION_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEE_ACCOUNT_OPERATION_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEE_AND_COID_MAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEE_AND_COID_MAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEE_SUB_ACCOUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEE_SUB_ACCOUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FEE_USE_RECORD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FEE_USE_RECORD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FILTERKEYWORD_LOGS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FILTERKEYWORD_LOGS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FILTER_KEYWORDS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FILTER_KEYWORDS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_FREEBACK');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_FREEBACK',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_GL_CORPORATION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_GL_CORPORATION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_GROUP_ROLES_MAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_GROUP_ROLES_MAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_HELP_CATALOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_HELP_CATALOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_HELP_CONTENT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_HELP_CONTENT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_IMPORT_CORPORATION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_IMPORT_CORPORATION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_IMPORT_USER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_IMPORT_USER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVITATION_CARDS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVITATION_CARDS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVITATION_CARD_APPLICATION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVITATION_CARD_APPLICATION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVITATION_CARD_CORPS_MAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVITATION_CARD_CORPS_MAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVITATION_CARD_LOGS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVITATION_CARD_LOGS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVITATION_CARD_SERVICE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVITATION_CARD_SERVICE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVITATION_CARD_USERS_MAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVITATION_CARD_USERS_MAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVIT_CARD_CHANGE_PARTNER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVIT_CARD_CHANGE_PARTNER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_INVOICE_INFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_INVOICE_INFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_IP_BLACKLIST');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_IP_BLACKLIST',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_IP_NEW1');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_IP_NEW1',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ISV_GRADE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ISV_GRADE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ISV_INFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ISV_INFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ISV_RECORD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ISV_RECORD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ISV_SERVICE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ISV_SERVICE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ITEM_TODO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ITEM_TODO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_JOIN_PARTNER_APPLICATION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_JOIN_PARTNER_APPLICATION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE15YEAR_YSOLDCUSTOMER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE15YEAR_YSOLDCUSTOMER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_AREA');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_AREA',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_CARD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_CARD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_DEPARTMENTS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_DEPARTMENTS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_GROUPS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_GROUPS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_KINGDEE15YEAR_QQ');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_KINGDEE15YEAR_QQ',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_ORGAN');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_ORGAN',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_ROLES');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_ROLES',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_SERIAL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_SERIAL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_USER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_USER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_KINGDEE_USERS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_KINGDEE_USERS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_LENOVO_USR_LOGIN');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_LENOVO_USR_LOGIN',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_LINK_MANAGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_LINK_MANAGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MAIL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MAIL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MARKETING_WAY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MARKETING_WAY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MEMBER_GRADE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MEMBER_GRADE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MEMBER_USER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MEMBER_USER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MODULE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MODULE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MODULE_ACCESSLOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MODULE_ACCESSLOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_ADD_ITEM');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_ADD_ITEM',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_COME_BANK_DEPOSIT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_COME_BANK_DEPOSIT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_COME_COMMON');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_COME_COMMON',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_COME_ONLINE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_COME_ONLINE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_COME_POST');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_COME_POST',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_FIXED_PRICE_STRATEGY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_FIXED_PRICE_STRATEGY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_ONLINE_PAY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_ONLINE_PAY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_ORDER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_ORDER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_ORDER2');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_ORDER2',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_ORDER_COPY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_ORDER_COPY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_ORDER_DISCOUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_ORDER_DISCOUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE_BUY_SMS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE_BUY_SMS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE_COPY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE_COPY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE_SAAS_UPDATE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE_SAAS_UPDATE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE_SAAS_UPDATE_BAK');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE_SAAS_UPDATE_BAK',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE_SAAS_UPGRADE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE_SAAS_UPGRADE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE_SERVICE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE_SERVICE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONEY_USE_SUBSCRIBE_FOR_SAAS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONEY_USE_SUBSCRIBE_FOR_SAAS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MONITOR_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MONITOR_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MSG_QUEUE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MSG_QUEUE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MY_MESSAGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MY_MESSAGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MY_MESSAGE_AUTH');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MY_MESSAGE_AUTH',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_MY_MESSAGE_HANDLED');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_MY_MESSAGE_HANDLED',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_NEWS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_NEWS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_NEWS_DETAIL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_NEWS_DETAIL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ONE_YEAR_CARD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ONE_YEAR_CARD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ONE_YEAR_REGISTER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ONE_YEAR_REGISTER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ONE_YEAR_SIGNUP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ONE_YEAR_SIGNUP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ONSITESERVICES');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ONSITESERVICES',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ORDER_RENEW');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ORDER_RENEW',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNERS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNERS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_BUY_STRATEGY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_BUY_STRATEGY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_CLEAR_TEST_RECORD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_CLEAR_TEST_RECORD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_DISCOUNT_RECORD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_DISCOUNT_RECORD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_DISCOUNT_RECORD_HIS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_DISCOUNT_RECORD_HIS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_DISCOUNT_STRATEGY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_DISCOUNT_STRATEGY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_DISCOUNT_STRATETY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_DISCOUNT_STRATETY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_GRADE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_GRADE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_GRADE_HISTORY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_GRADE_HISTORY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_SETTLE_SCORE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_SETTLE_SCORE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_SETTLE_SCORE_HIS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_SETTLE_SCORE_HIS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_SP_SERVICE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_SP_SERVICE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_STRATEGY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_STRATEGY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_STRATETY_CTRL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_STRATETY_CTRL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_TYPE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_TYPE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_TYPES');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_TYPES',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_USER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_USER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_USER_EVER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_USER_EVER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_USER_TMP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_USER_TMP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PARTNER_USER_TRANSFER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PARTNER_USER_TRANSFER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PICTURE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PICTURE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_POINTS_ACCOUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_POINTS_ACCOUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_POINTS_BILL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_POINTS_BILL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_POINTS_RULE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_POINTS_RULE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PREWARN');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PREWARN',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PREWARN_SMS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PREWARN_SMS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PREWARN_SMS_PAST');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PREWARN_SMS_PAST',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PRODUCT_TYPE_MAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PRODUCT_TYPE_MAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PROVINCE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PROVINCE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PROVINCE_AREA');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PROVINCE_AREA',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_PROVINCE_NEW');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_PROVINCE_NEW',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_RECOMMEND_DISCOUNT_STRATETY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_RECOMMEND_DISCOUNT_STRATETY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_RECOMMEND_SETTLE_SCORE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_RECOMMEND_SETTLE_SCORE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_REJECT_REASON');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_REJECT_REASON',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_REJECT_REASON_DETAIL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_REJECT_REASON_DETAIL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_REJECT_REASON_MAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_REJECT_REASON_MAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ROLES');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ROLES',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ROLE_AGENCY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ROLE_AGENCY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ROLE_AREA');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ROLE_AREA',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ROLE_AUTHORITIES');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ROLE_AUTHORITIES',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ROLE_AUTHORITY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ROLE_AUTHORITY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ROLE_CITY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ROLE_CITY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_ROLE_TYPE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_ROLE_TYPE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SAAS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SAAS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SAASFREEAPP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SAASFREEAPP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SAAS_AUDIT_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SAAS_AUDIT_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SAAS_EXPIRE_UPDATE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SAAS_EXPIRE_UPDATE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SAAS_SERVICE_APPLY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SAAS_SERVICE_APPLY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SALE_ORDER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SALE_ORDER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SEARCH_HOT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SEARCH_HOT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SERVICE_CHANGE_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SERVICE_CHANGE_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SMS_ACCOUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SMS_ACCOUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SMS_ACCOUNT_DISPATCHINFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SMS_ACCOUNT_DISPATCHINFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SMS_HISTORY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SMS_HISTORY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SMS_REMAINING');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SMS_REMAINING',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_ACCESSLOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_ACCESSLOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_ACCOUNTBILL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_ACCOUNTBILL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_ACCOUNTBILLLIST');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_ACCOUNTBILLLIST',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_ACCOUNTBILL_PARTNERS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_ACCOUNTBILL_PARTNERS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_ACCOUNTSET');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_ACCOUNTSET',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_ACCOUNTSET_TEMP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_ACCOUNTSET_TEMP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_MULTICURRENCY_PRICE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_MULTICURRENCY_PRICE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRESENT_STRATEGY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRESENT_STRATEGY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRICE_STRATEGY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRICE_STRATEGY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRODUCT_PRICE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRODUCT_PRICE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRODUCT_SAAS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRODUCT_SAAS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRODUCT_SAAS_UPDATE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRODUCT_SAAS_UPDATE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRODUCT_STRATEGY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRODUCT_STRATEGY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRODUCT_TYPE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRODUCT_TYPE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_PRODUCT_VAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_PRODUCT_VAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICEBILL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICEBILL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICEBILL_ITEM');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICEBILL_ITEM',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICE_ATTACH');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICE_ATTACH',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICE_BAK_20100513');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICE_BAK_20100513',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICE_DEPOT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICE_DEPOT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICE_DEPOT_TEMP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICE_DEPOT_TEMP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICE_JOIN');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICE_JOIN',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SP_SERVICE_VAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SP_SERVICE_VAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SRV_MAIL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SRV_MAIL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SRV_MAIL_PROVIDER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SRV_MAIL_PROVIDER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SRV_SMS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SRV_SMS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SRV_SMSACCT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SRV_SMSACCT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SRV_SMSPRCNTPY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SRV_SMSPRCNTPY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SSO_SESSION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SSO_SESSION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SSO_SP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SSO_SP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SSO_SP_SLO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SSO_SP_SLO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SSO_SP_SLO_COPY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SSO_SP_SLO_COPY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_STAT_INVITATION_CARD_USING');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_STAT_INVITATION_CARD_USING',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_STAT_MEMBER_COPY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_STAT_MEMBER_COPY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_STAT_MEMBER_COPY1');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_STAT_MEMBER_COPY1',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_STAT_USER_ANALYSIS_BAK0606');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_STAT_USER_ANALYSIS_BAK0606',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_STAT_USER_ANALYSIS_COPY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_STAT_USER_ANALYSIS_COPY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SUBSCRIPTION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SUBSCRIPTION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYSTEM_PARAM');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYSTEM_PARAM',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYSTEM_PREWARN');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYSTEM_PREWARN',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYS_CHECK');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYS_CHECK',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYS_PREF');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYS_PREF',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYS_PREF_ITEM');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYS_PREF_ITEM',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYS_SAAS_APP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYS_SAAS_APP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYS_SAAS_VENDOR');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYS_SAAS_VENDOR',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYS_UID_PARAMS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYS_UID_PARAMS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_SYS_UID_SEED');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_SYS_UID_SEED',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_TELECOM_USER_ACTIVE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_TELECOM_USER_ACTIVE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_TEMP_FIX_TELECOM');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_TEMP_FIX_TELECOM',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_TEMP_TELECOM_DATA');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_TEMP_TELECOM_DATA',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_TRAIN_FEEDBACK');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_TRAIN_FEEDBACK',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_TRAIN_SIGNUP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_TRAIN_SIGNUP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USBKEY_CERT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USBKEY_CERT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USBKEY_CERT_LOST');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USBKEY_CERT_LOST',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USBKEY_DELIVERY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USBKEY_DELIVERY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_AGENCY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_AGENCY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_BAK20100702');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_BAK20100702',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_CITY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_CITY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_DETAIL_FOR_ZHUHAI');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_DETAIL_FOR_ZHUHAI',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_FOR_LOGIN');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_FOR_LOGIN',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_LOGIN_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_LOGIN_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_LOGON_COUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_LOGON_COUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_NO_FOR_PROJ');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_NO_FOR_PROJ',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_RECALL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_RECALL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_ROLES_MAP');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_ROLES_MAP',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_SENDMAIL_COUNT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_SENDMAIL_COUNT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_USER_TYPE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_USER_TYPE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_WEBSITE_ACCESS_STAT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_WEBSITE_ACCESS_STAT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_WINNING_NUMS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_WINNING_NUMS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_WORKSPACE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_WORKSPACE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.T_YS_SUBSCRIPTION');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 'T_YS_SUBSCRIPTION',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_DEV.t_connect_table_for_c3p0');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_DEV',tabname => 't_connect_table_for_c3p0',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CATALOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CATALOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CATALOG_HOT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CATALOG_HOT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_BULLETIN');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_BULLETIN',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_BUSINESS_CARD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_BUSINESS_CARD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_CERTIFICATE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_CERTIFICATE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_KEYWORD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_KEYWORD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_LINKAGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_LINKAGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_MOBILE_KEYWORD');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_MOBILE_KEYWORD',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_PRODUCT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_PRODUCT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_RANK_IN_CATALOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_RANK_IN_CATALOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_RECOMMEND');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_RECOMMEND',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_SERVICE_SCOPE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_SERVICE_SCOPE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_STYLE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_STYLE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_CORPORATION_TRADE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_CORPORATION_TRADE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_DOMAIN_NAME');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_DOMAIN_NAME',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_FAVORITE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_FAVORITE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_GL_CASE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_GL_CASE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_GL_MESSAGE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_GL_MESSAGE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_GL_PERSON_EDUCATION_HISTORY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_GL_PERSON_EDUCATION_HISTORY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_GL_PERSON_WORK_HISTORY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_GL_PERSON_WORK_HISTORY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_GL_PRODUCT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_GL_PRODUCT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_GL_RECOMMEND_INFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_GL_RECOMMEND_INFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_GL_TEAM');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_GL_TEAM',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_OPERATION_LOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_OPERATION_LOG',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_PRODUCT');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_PRODUCT',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_PRODUCT_TYPE');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_PRODUCT_TYPE',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_PROVIDING_DESC');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_PROVIDING_DESC',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_PROVIDING_DETAIL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_PROVIDING_DETAIL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_PROVIDING_ESSENTIAL');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_PROVIDING_ESSENTIAL',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_PUBLISH_TASKS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_PUBLISH_TASKS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_PURCHASE_INFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_PURCHASE_INFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_RECOMMEND_COMPANY');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_RECOMMEND_COMPANY',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_RECOMMEND_INFO');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_RECOMMEND_INFO',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_SEARCH_LOGS');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_SEARCH_LOGS',cascade => true,estimate_percent => 50);
exec dbms_output.put_line('start to statistics table PLATFORM_B2B.T_SYS_EVENTLOG');
exec dbms_stats.gather_table_stats(ownname => 'PLATFORM_B2B',tabname => 'T_SYS_EVENTLOG',cascade => true,estimate_percent => 50);

 

 

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15119715/viewspace-677123/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15119715/viewspace-677123/

cuiliujue5300
关注
Oracle集群RAC磁盘管理命令asmcmd的使用
没刮胡子的程序员专栏
07-23 258
ASM（Automatic Storage Management）磁盘共享是Oracle数据库中一项重要的存储管理技术，旨在简化数据库管理员（DBA）对存储资源的管理，提高存储效率和数据可用性。以下是对ASM磁盘共享的详细简介：ASM是Oracle提供的一种智能化数据库文件存储管理解决方案，它采用Oracle Managed Files（OMF）文件格式来创建目录文件，能够在多个物理设备之间实现条带化、镜像数据文件、恢复文件等功能。
ORACLE+RAC原理与实践系列：1 RAC安装
本博客纯属个人学习记载，不对外负责，若有错误，请批评指正
01-29 1067
需求与环境 安装部署ORACLE 19c RAC环境。55.34.4.153、55.34.4.154；两台vmware主机分别配置两个网卡，申请5个同网段的IP（公网IP），两台vmware主机配置三块共享盘（OCRDG、DATADG、FRADG）； 前期准备 创建grid用户(双节点) useradd grid groupadd oinstall groupadd dba groupadd oper groupadd asmadmin ...
Oracle 11g RAC常用检查操作指令实验
blockheading的博客
02-09 1481
--Oracle 11g RAC常用检查操作指令实验 --启动cluster，两个节点分别执行 [root@rac1 ~]# /u01/app/11.2.0/grid/bin/crsctl start crs CRS-4123: Oracle High Availability Services has been started. [root@rac2 ~]# /u01/app/11.2.0/g
RAC/RAC One Node创建dataguard
Du.的博客
04-16 526
环境介绍 站点 原db_unique_name 准备修改的db_unique_name scanip vip PR prov pr_mexprov 10.208.154.15 10.208.154.13 10.208.154.14 DR prov
《Oracle RAC 核心技术详解》 Question and Answer
liuhhaiffeng的专栏
06-02 2013
《Oracle RAC 核心技术详解》 Question and Answer 第一部分 集群管理软件 集群技术简介 EVM, CRS, CSS Oracle10g版本, Oracle推出了自己的集群管理软件产品----CRS (Cluster Ready Service). 对于集群管理软件—CRS, 主要分为3个组件: CSS (Cluster Synchronization Service), CRS (Cluster Ready Service) 和 EVM (Event Manager). CSS
Oracle rac功能测试方案
10-29
### Oracle RAC 功能测试方案详解 ...通过对测试方案的实施，不仅可以确保系统上线前的各项功能达到预期效果，还可以帮助企业更好地理解Oracle RAC的工作机制，从而提高整体运维效率和技术支持水平。
Oracle RAC 删除grid，oracle后重新安装 grid，oracle 软件和重建数据库
06-26
Oracle RAC环境下的数据库操作是一项复杂的工作，尤其是涉及到删除和重新安装Grid Infrastructure及Oracle数据库的情况。这个过程通常是为了升级到企业版或者解决某些特定的技术问题。以下是对整个流程的详细解释： ...
4.网络编程
weixin_45476535的博客
09-14 407
程序注册端口：1024-49151。单个协议下，端口号不能冲突。公有端口0-1023。
Oracle EBS中AR模块的财务流程概览
qq_36620997的博客
09-14 716
AR模块的财务流程概览
【学习笔记】手写 Tomcat 三
LearnTech_123的博客
09-12 1090
响应动态资源不需要写文件名了，只需要写功能的名称即可。比如登录功能，可以定义名称为 doLogin
55 mysql 的登录认证流程
最新发布
970655147的专栏
09-15 593
这里我们来看一下 mysql 的认证的流程我们这里仅仅看 我们最常见的一个 认证的处理流程我们经常会登录的时候 碰到各种异常信息大概的流程是这样客户端和服务器建立连接之后, 服务器向客户端发送 salt然后 客户端根据 salt 将客户端传入的密码加密之后, 以及相关登录信息传递给服务器然后 服务器进行验证, 验证失败, 响应对应的错误信息给客户端服务器发送 salt 的信息如下客户端发送的认证请求如下服务器响应的认证失败信息如下。
PHP在现代Web开发中的高效应用与最佳实践
运维人生
09-13 976
我们将使用Laravel框架来构建一个简单的博客系统，该系统包括文章发布、编辑、查看和评论等功能。PHP作为一门成熟且强大的服务器端脚本语言，在现代Web开发中依然扮演着重要角色。通过遵循最佳实践、利用现代PHP版本的特性和成熟的框架与组件，开发者可以高效构建出稳定、安全、可扩展的Web应用。本文通过一个简单的博客系统案例，展示了PHP在实际项目中的应用方法和技巧，希望能为PHP开发者提供一些有益的参考和启发。
linux环境下手动安装mysql
weixin_45583482的博客
09-14 780
没想到兜兜转转这么些年，今天申请个云服务器用来搭建求生2服务器，先用mysql来测试，结果还是花了相当久的时间。基本所有单节点部署应用到linux环境，都三个流程：1 下载安装包2 解压修改配置文件3 运行启动脚本我们按这个流程来说我遇到并解决的问题 ，如果你在过程中遇到什么问题，也请先暂停你的启动流程，移步到最下面的内容，看看是否有和你遇到一样的问题，解决以后继续。
转行软件测试工程师经验总结
2402_84109700的博客
09-12 544
数据安全官，CCRC-DSA数据安全评估师，CCRC-DCO数据合规官，CDO首席数据官, ITSS IT服务项目经理，IT服务项目工程师，ISO27001,CISP,软考,CISAW应急服务方向,CISAW渗透测试方向,软考,CCSC网络安全能力,工信部教考中心计算机网络安全相关认证办理。在测试理论方面，要熟悉常用的测试用例设计方法，理解不同测试类型的特点，掌握测试用例的基本格式，以及测试结束的标准。最终，我如愿以偿地加入了一家互联网公司，这里的办公环境优越，薪资也较之前的工作有所提升，使我心情愉悦。
关于新版本 tidb dashboard API 调用说明
TiDB 社区干货传送门
09-11 337
作者： WalterWj 原文来源： https://tidb.net/blog/d2d669b2 ...
mycat双主高可用架构部署-水评分表-范围分片配置
龙哥·三年风水从2011年开始做IT工作，从ps画图到前端开发->后端开发->框架开发->业务架构设计及开发->业务需求整理、开发->技术经理->技术总监
09-11 1268
mycat双主高可用架构部署-水评分表-范围分片配置
OpenJDK 8 安装指南
专注于全栈开发领域
09-12 1202
在分布式系统中，Apache Kafka 是一个非常受欢迎的消息中间件。它提供了高吞吐量、低延迟的消息传递机制，非常适合处理实时数据流。本文将介绍如何在 Java 中使用 Kafka Producer 并实现单例模式，以确保资源的有效管理。Kafka 是一个分布式流处理平台，它的核心功能包括发布和订阅记录流、存储流记录、以及处理流记录。为了充分利用 Kafka 的功能，一个高效的 Kafka 生产者（Producer）是必要的。
Oracle RAC数据库启动与关闭操作指南
"该文档详细介绍了Oracle RAC数据库的正常启动和关闭操作步骤，适合数据库操作人员参考。" 在Oracle数据库操作中，特别是对于Real Application Clusters (RAC)环境，正确的启动和关闭过程至关重要，以确保数据的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值