oracle addm详解,oracle addm segment tuning

最近客户出现一次，数据库性能问题，业务访问某个表时，非常慢，后来查看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.