【慢】OA系统慢可做的几步【二】

如果数据库使用的是oracle数据库查看系统资源 SELECT resource_name,current_utilization,max_utilization,LIMIT,ROUND (max_utilization / LIMIT * 100) || '%' rate FROM (SELECT resource_name,current_utilization,max_utilization,TO_NUMBER (initial_allocation) LIMIT FROM v$resource_limit WHERE resource_name IN ('processes', 'sessions') AND max_utilization > 0);RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT RATE------------------------------ ------------------- --------------- ---------- -----processes 312 500 500 100%sessions 317 509 555 92%发现是资源不足。处理方法是：alter system set processes=1000 scope=spfile;alter system set sessions=1110 scope=spfile; 然后重启数据库

给OA表建索引 create index index_file2 on workflow_file(user_id);create index index_file3 on workflow_file(flow_id);create index index_file4 on workflow_file(flowtype_id);create index index_file5 on workflow_file(dept_id);create index index_file6 on workflow_file(submitdate);create index index_fileattach1 on workflow_fileattach (file_id);create index index_fileattach2 on workflow_fileattach (user_id);create index index_fileattach3 on workflow_fileattach (topic_id);create index index_fileattach4 on workflow_fileattach (outuser_id);create index index_fileinbox2 on workflow_fileinbox(file_id);create index index_fileinbox3 on workflow_fileinbox(user_id);create index index_fileinbox4 on workflow_fileinbox(startdate);create index index_fileinbox5 on workflow_fileinbox(flow_id);create index index_fileinbox6 on workflow_fileinbox(step_id);create index index_fileinbox7 on workflow_fileinbox(token);create index index_fileprocess2 on workflow_fileprocess(file_id);create index index_fileprocess3 on workflow_fileprocess(step_pid);create index index_fileprocess4 on workflow_fileprocess(user_pid);create index index_fileprocess5 on workflow_fileprocess(step_id);create index index_fileprocess6 on workflow_fileprocess(user_id);create index index_fileprocess7 on workflow_fileprocess(inbox_id);create index index_fileprocess8 on workflow_fileprocess(token_id);create index index_fileno2 on workflow_fileno(flowtype_id);create index index_fileopinion2 on workflow_fileopinion(file_id);create index index_fileopinion3 on workflow_fileopinion(step_id);create index index_fileopinion4 on workflow_fileopinion(user_id);create index index_flowfield1 on workflow_flowfield(flowtype_id);create index index_sysusers_1 on system_users (superior);create index index_sysusers_2 on system_users (dept_id);create index index_sysusers_3 on system_users (ucdept_id);create index index_sysusers_4 on system_users (loginid);create index index_sysdept_1 on system_depts (superior);create index index_sysdept_2 on system_depts (ucdept_id);create index index_sysarea_1 on system_area (dept_id);create index index_sysposmember_1 on system_positionmember (user_id);create index index_sysposmember_2 on system_positionmember (position_id);create index index_docexfileattach1 on docex_fileattach (file_id);create index index_docexfileattach2 on docex_fileattach (user_id);create index index_docexfileattach3 on docex_fileattach (fileopinion_id);create index index_docexfileattach4 on docex_fileattach (topic_id);create index index_docexfileattach5 on docex_fileattach (createdate);create index index_docexfiledetail1 on docex_filedetail (file_id);create index index_docexfiledetail2 on docex_filedetail (readuser_id);create index index_docexfiledetail3 on docex_filedetail (createdate);create index index_docexfileopinion1 on docex_fileopinion (user_id);create index index_docexfileopinion2 on docex_fileopinion (docexfile_id);create index index_docexfileopinion3 on docex_fileopinion (docexfiledetail_id);