SQL> exec show_space('INV_MONTH_END_LOCATION', 'INVENTORY');Unformatted Blocks ..................... 0FS1 Blocks (0-25) ..................... 0FS2 Blocks (25-50) ..................... 0FS3 Blocks (50-75) ..................... 0FS4 Blocks (75-100)..................... 0Full Blocks ..................... 0Total Blocks............................ 434,176Total Bytes............................. 3,556,769,792Total MBytes............................ 3,392Unused Blocks........................... 434,142Unused Bytes............................ 3,556,491,264Last Used Ext FileId.................... 40Last Used Ext BlockId................... 9Last Used Block......................... 34PL/SQL procedure successfully completed.SQL> exec show_space('INV_MONTH_END_LOCATION', 'INVENTORY');Unformatted Blocks ..................... 0FS1 Blocks (0-25) ..................... 0FS2 Blocks (25-50) ..................... 0FS3 Blocks (50-75) ..................... 0FS4 Blocks (75-100)..................... 0Full Blocks ..................... 0Total Blocks............................ 434,176Total Bytes............................. 3,556,769,792Total MBytes............................ 3,392Unused Blocks........................... 434,142Unused Bytes............................ 3,556,491,264Last Used Ext FileId.................... 40Last Used Ext BlockId................... 9Last Used Block......................... 34PL/SQL procedure successfully completed.
oracle如何修改initial参数,INITIAL参数设置罗致TRUNCATE TABLE不能降低高水位线案例...
最新推荐文章于 2023-05-04 15:21:20 发布
该SQL查询结果显示了'INV_MONTH_END_LOCATION'表在'INVENTORY'数据库中的空间使用情况。表总共有434,176个块，其中434,142个块未使用，总大小为3,556,769,792字节，大部分空间目前是空闲的。
981
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
