Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Query: Extents of a Fragment/Partition
31 views
Skip to first unread message
red_valsen
Oct 12, 2012, 6:43:17 PM10/12/12
to
Does anybody have a query that produces a listing of extents by fragment in a partitioned table -- something like what oncheck -pT reports for the fragmented table? I need to determine how large each partition is via SQL, but haven't been able to determine what sysmaster & system catalog tables can give me that information.
Using IDS 10&11.
Using IDS 10&11.
0 new messages