我家的OA系统,最近发现EM中有很多提示,由于SQL语句的执行,导致系统性能严重下降的问题,我查了一下详细的语句内容:FINDING 1: 60% impact (283 seconds)
-----------------------------------
发现 SQL 语句消耗了大量数据库时间。 RECOMMENDATION 1: SQL Tuning, 39% benefit (181 seconds)
ACTION: 对 SQL_ID 为 "800k8b8vaq88z" 的 SQL 语句运行 SQL Tuning Advisor。
RELEVANT OBJECT: SQL statement with SQL_ID 800k8b8vaq88z and
PLAN_HASH 2916081355
select docresourc0_.id as id32_, docresourc0_.access_count as
access2_32_, docresourc0_.comment_count as comment3_32_,
docresourc0_.comment_enabled as comment4_32_,
docresourc0_.create_time as create5_32_, docresourc0_.create_user_id
as create6_32_, docresourc0_.doc_lib_id as doc7_32_,
docresourc0_.fr_desc as fr8_32_, docresourc0_.fr_name as fr9_32_,
docresourc0_.fr_order as fr10_32_, docresourc0_.fr_size as fr11_32_,
docresourc0_.fr_type as fr12_32_, docresourc0_.last_update as
last13_32_, docresourc0_.last_user_id as last14_32_,
docresourc0_.parent_fr_id as parent15_32_, docresourc0_.source_id as
source16_32_, docresourc0_.status as status32_,
docresourc0_.status_date as status18_32_,
docresourc0_.subfolder_enabled as subfolder19_32_,
docresourc0_.is_folder as is20_32_, docresourc0_.logical_path as
logical21_32_, docresourc0_.mime_type_id as mime22_32_,
docresourc0_.is_check_out as is23_32_, docresourc0_.check_out_user_id
as check24_32_, docresourc0_.check_out_time as check25_32_,
docresourc0_.key_words as key26_32_, docresourc0_.has_attachments as
has27_32_, docresourc0_.is_learning_doc as is28_32_,
docresourc0_.third_hasPingHole as third29_32_,
docresourc0_.mime_order as mime30_32_ from doc_resources docresourc0_
where docresourc0_.create_user_id=:1 and docresourc0_.fr_type=:2
RATIONALE: SQL_ID 为 "800k8b8vaq88z" 的 SQL 语句执行了 3906 次, 每次执行平均用时 0.049
秒。
我把这个语句拿到PL SQL中执行,但提示有错误,没有办法执行出正确结果,由于我对表结构并不熟悉,所以现在想请坛里的高人能不能分析一下,这么短的时间,反复执行同一语句,并且严重影响了系统性能,是不是我的系统被人攻击了啊
-----------------------------------
发现 SQL 语句消耗了大量数据库时间。 RECOMMENDATION 1: SQL Tuning, 39% benefit (181 seconds)
ACTION: 对 SQL_ID 为 "800k8b8vaq88z" 的 SQL 语句运行 SQL Tuning Advisor。
RELEVANT OBJECT: SQL statement with SQL_ID 800k8b8vaq88z and
PLAN_HASH 2916081355
select docresourc0_.id as id32_, docresourc0_.access_count as
access2_32_, docresourc0_.comment_count as comment3_32_,
docresourc0_.comment_enabled as comment4_32_,
docresourc0_.create_time as create5_32_, docresourc0_.create_user_id
as create6_32_, docresourc0_.doc_lib_id as doc7_32_,
docresourc0_.fr_desc as fr8_32_, docresourc0_.fr_name as fr9_32_,
docresourc0_.fr_order as fr10_32_, docresourc0_.fr_size as fr11_32_,
docresourc0_.fr_type as fr12_32_, docresourc0_.last_update as
last13_32_, docresourc0_.last_user_id as last14_32_,
docresourc0_.parent_fr_id as parent15_32_, docresourc0_.source_id as
source16_32_, docresourc0_.status as status32_,
docresourc0_.status_date as status18_32_,
docresourc0_.subfolder_enabled as subfolder19_32_,
docresourc0_.is_folder as is20_32_, docresourc0_.logical_path as
logical21_32_, docresourc0_.mime_type_id as mime22_32_,
docresourc0_.is_check_out as is23_32_, docresourc0_.check_out_user_id
as check24_32_, docresourc0_.check_out_time as check25_32_,
docresourc0_.key_words as key26_32_, docresourc0_.has_attachments as
has27_32_, docresourc0_.is_learning_doc as is28_32_,
docresourc0_.third_hasPingHole as third29_32_,
docresourc0_.mime_order as mime30_32_ from doc_resources docresourc0_
where docresourc0_.create_user_id=:1 and docresourc0_.fr_type=:2
RATIONALE: SQL_ID 为 "800k8b8vaq88z" 的 SQL 语句执行了 3906 次, 每次执行平均用时 0.049
秒。
我把这个语句拿到PL SQL中执行,但提示有错误,没有办法执行出正确结果,由于我对表结构并不熟悉,所以现在想请坛里的高人能不能分析一下,这么短的时间,反复执行同一语句,并且严重影响了系统性能,是不是我的系统被人攻击了啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货