最近客户出现一次,数据库性能问题,业务访问某个表时,非常慢,后来查看addm报告,
建议对这个表重建,重建后恢复正常。 可能是这个表产生碎片太多。
Recommendation 1: Segment Tuning
Estimated benefit is 354.08 active sessions, 100% of total activity.
--------------------------------------------------------------------
Action
Run "Segment Advisor" on TABLE PARTITION
"DB.OPINION_INST.00000" with object ID 66801.
Related Object
Database object with ID 66801.
Action
Investigate application logic involving I/O on TABLE PARTITION
"DB_EXOA.MV_OPINION_INST.DC_WFOI500000" with object ID 66801.
Related Object
Database object with ID 66801.
Action
Look at the "Top SQL Statements" finding for SQL statements consuming
significant I/O on this segment. For example, the SELECT statement with
SQL_ID "4sfsdc5cxbb9t" is responsible for 28% of "User I/O" and
"Cluster" waits for this segment.
Rationale
The I/O usage statistics for the object are: 823 full object scans,
106338050 physical reads, 5 physical writes and 106337547 direct reads.
Estimated benefit is 354.08 active sessions, 100% of total activity.
--------------------------------------------------------------------
Action
Run "Segment Advisor" on TABLE PARTITION
"DB.OPINION_INST.00000" with object ID 66801.
Related Object
Database object with ID 66801.
Action
Investigate application logic involving I/O on TABLE PARTITION
"DB_EXOA.MV_OPINION_INST.DC_WFOI500000" with object ID 66801.
Related Object
Database object with ID 66801.
Action
Look at the "Top SQL Statements" finding for SQL statements consuming
significant I/O on this segment. For example, the SELECT statement with
SQL_ID "4sfsdc5cxbb9t" is responsible for 28% of "User I/O" and
"Cluster" waits for this segment.
Rationale
The I/O usage statistics for the object are: 823 full object scans,
106338050 physical reads, 5 physical writes and 106337547 direct reads.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-758803/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-758803/