用友NC5.5测试环境配置手册.docx

安装ORACLE进入命令行cmdsqlplus/as sysdba建立oracle表空间：“E:\NC55_tablespaces”为相应表空间存储路径。CREATE TABLESPACE NNC_DATA01 DATAFILE E:\NC55_tablespaces\nnc_data01.dbf SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;CREATE TABLESPACE NNC_DATA02 DATAFILE E:\NC55_tablespaces\nnc_data02.dbf SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; CREATE TABLESPACE NNC_DATA03 DATAFILE E:\NC55_tablespaces\nnc_data03.dbf SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;CREATE TABLESPACE NNC_INDEX01 DATAFILE E:\NC55_tablespaces\nnc_index01.dbf SIZE 500M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;CREATE TABLESPACE NNC_INDEX02 DATAFILE E:\NC55_tablespaces\nnc_index02.dbf SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ; CREATE TABLESPACE NNC_INDEX03 DATAFILE E:\NC55_tablespaces\nnc_index03.dbf SIZE 500M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;CREATE USER NC55 IDENTIFIED BY NC50 DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;GRANT connect,dba to NC55;COMMIT;Oracle数据库优化对于Oracle用户，更新指定表统计信息方法需要在sqlplus中执行。下面是在sqlplus中执行优化操作命令，NC5.5是当前系统存储业务数据的用户。这个存促过程执行中，如果个别表分析出错后，会继续处理其他表，并将错误信息写入analyze_log表。 SQLconnect NC35/NC35@oracleSQLgrant create any table to nc35 ; -- 这一步非常重要，需要显式地赋予用户建表权限SQL CREATE OR REPLACE PROCEDURE ANALYZE_TB AS V_TABLENAME VARCHAR2(50); --table的名称 v_indexname varchar2(50);--index的名称 V_SQL VARCHAR2(300); V_SQL1 VARCHAR2(300); OWNER_NAME VARCHAR2(100); V_LOG INTEGER; CURSOR CUR_TABLE IS -- 游标 SELECT TABLE_NAME FROM USER_TABLES WHERE temporary=N; --no temp table CURSOR CUR_TABLE_TEMP IS SELECT TABLE_NAME FROM USER_TABLES WHERE temporary=Y; CURSOR CUR_LOG IS SELECT COUNT(TABLE_NAME) FROM USER_TABLES WHERE TABLE_NAME=ANALYZE_LOG; CURSOR cur_index IS select index_name from user_indexes group by index_name; BEGIN --DBMS_OUTPUT.ENABLE (buffer_size=100000); BEGIN OPEN CUR_LOG; FETCH CUR_LOG INTO V_LOG; IF V_LOG=0 THEN EXECUTE I