Oracle：确定分区大小
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/19451245/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle: Determine Partition Size
提问by Amit Arora
I have a table with 200 hash partitions, I like to monitor daily size growth (rows and size in MB) for each of the partition. For more information, another process loads / updates rows on this table on daily basis and I like to know the growth pattern.
我有一个包含 200 个哈希分区的表，我喜欢监视每个分区的每日大小增长（行和大小以 MB 为单位）。有关更多信息，另一个进程每天加载/更新此表上的行，我想知道增长模式。
I am not looking for overall table size script, but size of each partition.
我不是在寻找整体表大小脚本，而是每个分区的大小。
回答by Emyl
You can check the size of your partitions with this statement:
您可以使用以下语句检查分区的大小：
SELECT partition_name, bytes/1024/1024 "MB"
FROM dba_segments
WHERE segment_name = 'MYTABLE'
AND segment_type = 'TABLE PARTITION';
