oracle表数据大小
时间: 2023-10-17 07:36:25 浏览: 42
要查询Oracle表的数据大小,可以使用以下SQL语句:
SELECT round(sum(bytes)/1024/1024/1024, 4) GB FROM user_segments WHERE segment_type = 'TABLE';
这个查询语句会返回表的数据大小,单位是GB。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [oracle-查看数据表容量大小](https://blog.csdn.net/shuaishuai1234/article/details/84870700)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [atabase-export是一款多线程生成数据库结构文档的开源springboot工程,能支持最新的数据库版本,支持导出...](https://download.csdn.net/download/weixin_41037490/88279202)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]