请问各位老大awr中SegmentStatistics是哪个基表查出来的?如何查段的逻辑读物理读等?

yueli33

awr中Segment Statistics包括了如下内容
Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

请问各位老大awr中SegmentStatistics是怎么查出来的?
有一些表想单独查一下。而且awr东西比较多，有时候不需要那么多，想单弄个语句查segment的这些情况。
再就是awr应该是可以调整的，SegmentStatistics出来是top5，想调成top10怎么弄？


谢谢各位老大！

lfree

应该是dba开头,中间seg的试图.你检查看看.

lfree

V$SEGMENT_STATISTICS

lfree

V$SEGMENT_STATISTICS