前台反应响应时间很长,
首先,看看Oracle正在做些什么。
分析这个SQL
执行顺序应该是 8,7,6,5,4,9,3,10,2,1,0
参考:
http://www.askmaclean.com/archives/read-sql-execution-plan.html
首先,看看Oracle正在做些什么。
SELECT a.username, b.sql_id, b.SQL_TEXT, b.SQL_FULLTEXT
FROM v$session a, v$sqlarea b
WHERE a.sql_address = b.address
AND a.SQL_HASH_VALUE = b.HASH_VALUE
找到问题SQL的sql_id,然后查看执行计划FROM v$session a, v$sqlarea b
WHERE a.sql_address = b.address
AND a.SQL_HASH_VALUE = b.HASH_VALUE
select * from table(dbms_xplan.display_awr('2k55nnc3y1xw4'));
分析这个SQL
执行顺序应该是 8,7,6,5,4,9,3,10,2,1,0
SELECT opus_type, a.opus_id, opus_name, a.userid, nickname
, performer, visit_num,
to_char(a.createtime, 'yyyy-mm-dd') AS createtime,
file_domain, upload_domain
, file_url, round(file_size / 1024000, 2) AS file_size
FROM (
SELECT rid
FROM (
SELECT rownum AS rn, rid
FROM (
SELECT rowid AS rid
FROM music_video a
WHERE 1 = 1
AND opus_stat = 1
AND auditing = 1
AND convert_mark = 1
ORDER BY a.createtime DESC
)
WHERE rownum <= :1
)
WHERE rn >= :2
) t, music_video a, space_user b
WHERE t.rid = a.ROWID
AND a.userid = b.userid
ORDER BY a.createtime DESC
关于执行计划顺序的纠正:, performer, visit_num,
to_char(a.createtime, 'yyyy-mm-dd') AS createtime,
file_domain, upload_domain
, file_url, round(file_size / 1024000, 2) AS file_size
FROM (
SELECT rid
FROM (
SELECT rownum AS rn, rid
FROM (
SELECT rowid AS rid
FROM music_video a
WHERE 1 = 1
AND opus_stat = 1
AND auditing = 1
AND convert_mark = 1
ORDER BY a.createtime DESC
)
WHERE rownum <= :1
)
WHERE rn >= :2
) t, music_video a, space_user b
WHERE t.rid = a.ROWID
AND a.userid = b.userid
ORDER BY a.createtime DESC
参考:
http://www.askmaclean.com/archives/read-sql-execution-plan.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29254281/viewspace-1153757/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29254281/viewspace-1153757/