1分钟处理数据库程序慢的问题(某医院)

1、10个最耗资源的语句
SELECT * FROM (select PARSING_USER_ID,EXECUTIONS,SORTS,
COMMAND_TYPE,DISK_READS,sql_text FROM v$sqlarea
order BY disk_reads DESC )where ROWNUM<10 ;
2、语句执行计划

3、YZ_JCSQD
SQL> select count(*) from YZ_JCSQD;

COUNT(*)
———-
538281

SQL> SELECT COUNT(*) FROM ZY_PATIENT_INFORMATION;

COUNT(*)
———-
123028

500多万和12万走全表扫描。提交给软件公司,加索引